Remove first word in a string

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
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

sudeep

New Member
Joined
Nov 28, 2006
Messages
39
Hee Hee,

I just use find and replace. It works.

Thanks,

Sid
 

smrkhan

New Member
Joined
Mar 30, 2015
Messages
1
Can you please explain why this - is used for??

I mean i was trying to translate the formula but i couldn't understand, what is the function of "-" in the formula
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,186
Office Version
2010
Platform
Windows
Can you please explain why this - is used for??

I mean i was trying to translate the formula but i couldn't understand, what is the function of "-" in the formula
Which formula are you referring to? A quick look at all of them seems to indicate it is used as a minus sign, indicating subtraction, in those formulas contain it.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,969
Messages
5,508,466
Members
408,686
Latest member
celobacara

This Week's Hot Topics

Top