Notes tests, string, manipulation of text files and string manipulations

later

Some extended notes and explanations for this main Guru Post from Rick Rothstein
https://www.excelfox.com/forum/showt...ed-Text-String

---

Some extended Explanation/ Analysis of a formula from Rick,
=TRIM(MID(SUBSTITUTE(A1,delimiter,REPT(" ",99)),fieldnumber*99-98,99))
for the reasons of
_me to understand it, and also,
_ for completeness to answer this :

Quote:

---

Originally Posted by MGirvin

but why does it need the minus 1 (98 = 99-1)? What is the situation that would lead to trouble if you did not have the minus 1?

---