Home

Find string function, right-to-left

Highlighted
David Fishman
Occasional Visitor

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.

1 Reply
Highlighted

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?

Related Conversations
Make Share function in Edge more useful
HotCakeX in Discussions on
2 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Combining IF and INDEX functions
Hans van Deursen in Windows PowerShell on
2 Replies