I need to extract the last word in a column that has either two or three words and the first or first and second word. Is this possible? I have attached a sample file.
Thanks in advance
I need to extract the last word in a column that has either two or three words and the first or first and second word. Is this possible? I have attached a sample file.
Thanks in advance
Last edited by Aland2929; 03-24-2012 at 07:35 AM.
try this:
In C2
In B2:![]()
Please Login or Register to view this content.
Copy both down![]()
Please Login or Register to view this content.
Quang PT
Fantastic. Thanks so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks