Forum Discussion

David Fishman's avatar
David Fishman
Copper Contributor
Oct 16, 2018

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.

excel
Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 16, 2018

    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?

Resources