Ged Traynor
Board Regular
- Joined
- Oct 12, 2007
- Messages
- 73
Hi All,
I want to remove the first from from a string in Column A
Example
Miss Joan Smith
Mr Tom Colye
What I want to be left with is
Joan Smith
Tom Colye
I came across this formula to remove the last word in a string but can't figure out how to change it to remove the first word
=LEFT(A1,LOOKUP(2^15,FIND(" "," "&A1,ROW(INDIRECT("1:"&LEN(A1)))))-1)
Thanks in Advance
Ged
I want to remove the first from from a string in Column A
Example
Miss Joan Smith
Mr Tom Colye
What I want to be left with is
Joan Smith
Tom Colye
I came across this formula to remove the last word in a string but can't figure out how to change it to remove the first word
=LEFT(A1,LOOKUP(2^15,FIND(" "," "&A1,ROW(INDIRECT("1:"&LEN(A1)))))-1)
Thanks in Advance
Ged