Remove first word in a string

[Ged Traynor]

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

 

[VoG]

Try

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

 

[Ged Traynor]

Thanks very much for the quick response

Works Great

Cheers

 

[SteveO59L]

=mid(a1,find(" ",a1)+1,len(a1))

 

[sudeep]

Hee Hee,

I just use find and replace. It works.

Thanks,

Sid

 

[smrkhan]

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]

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.