Forum Discussion
ArchiveUser
10 years agoQrew Captain
Looks like this is due to the way Left and Right work - per the documentation:
"The second argument, d, is a text value containing all the possible delimiter characters."
So it seems each character put in the formula acts as a delimiter, rather than the whole string. Is it possible for a string to act as a delimiter rather than the individual characters?
"The second argument, d, is a text value containing all the possible delimiter characters."
So it seems each character put in the formula acts as a delimiter, rather than the whole string. Is it possible for a string to act as a delimiter rather than the individual characters?