hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,226
- Office Version
- 2010
- Platform
- Windows
- Mobile
I am having 'NAMES' in column X5:X9999. NAMES contains 4 words MAXIMUM of alphanumeric characters separated by either a blank or "/" or "-".
How to get the last word from the NAMES? All output required in UPPERCASE only in column Z5:Z9999
Ex:
PETER ENGLAND ENGLAND
sUN/Water-Rose Prime PRIME
Daniel Murray-8horse/55buffALo123 55BUFFALO123
riSiNg888 RISING888
I am using Excel2007. Thanks in advance.
How to get the last word from the NAMES? All output required in UPPERCASE only in column Z5:Z9999
Ex:
PETER ENGLAND ENGLAND
sUN/Water-Rose Prime PRIME
Daniel Murray-8horse/55buffALo123 55BUFFALO123
riSiNg888 RISING888
I am using Excel2007. Thanks in advance.
