Oct 16 2018 08:49 AM
I'm looking for a function to identify the last appearance of a string within a text, i.e. right-to-left. Especially interested in finding last space character in a text.
Oct 16 2018 08:54 AM
David, position of the last space is
=LOOKUP(2^30,FIND(" ",A1,ROW(INDIRECT("1:"&LEN(A1)))))
What do you mean under last appearance of a string within a text?