CODEWITHSUNDEEP
excelstring
Goodwill
Goodwill

Reputation: 53

Excelsheet query

How can I find the last word from any particular cell in excel sheet if cell contains multiple words or instructions?

For ex- The below string is in particular cell:

C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue hills.jpg

My requirement is to search only last word in that cell i.e. Blue hills.jpg.

Upvotes: 0

Views: 79

Answers (1)

ivan
ivan

Reputation: 430

If "\" is you delimiter then this formula will do the trick. Just replace E5 with your cell.

=CLEAN(TRIM(RIGHT(E5;LEN(E5)-FIND("*";SUBSTITUTE(E5;"\";"*";LEN(E5)-LEN(SUBSTITUTE(E5;"\";"")))))))

Upvotes: 2

Related Questions