How can I perform a reverse string search in Excel without using VBA?
- by e.James
I have an Excel spreadsheet containing a list of strings. Each string is made up of several words, but the number of words in each string is different.
Using built in Excel functions (no VBA), is there a way to isolate the last word in each string?
Examples:
Are you classified as human? - human?
Negative, I am a meat popsicle - popsicle
Aziz! Light! - Light!