Forum Discussion
David Fishman
Oct 16, 2018Copper Contributor
Find string function, right-to-left
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.
SergeiBaklan
Oct 16, 2018MVP
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?