Log in  \/ 
Register  \/ 


 How to apply the reverse find or search function in Excel?

Generally, we can apply the Find or Search function to look for a specific text from left to right in a text string by a specific delimiter. If you need to reverse the find function to look for the word starting at the end of a string as following screenshot shown, how could you do?

Apply the reverse find function to look for the word from right in text string with formula


To get the last word from right in text string, the following formula may help you, please do as this:

Enter this formula: =TRIM(RIGHT(SUBSTITUTE(TRIM(A2), " ", REPT(" ", 99)), 99)) into a blank cell, and then drag the fill handle down to the cells that you want to extract the last word, and all last word in the text strings have been displayed at once, see screenshot:

Note: The formula only can find word from right based on space delimiter.

The Best Office Productivity Tools


kte tab 201905


officetab bottom
Say something here...
symbols left.
You are guest

Be the first to comment.