minus first word in column

[Guest]

In Column L, I have a persons first name and last name eg: John Smith. In
column N, I just want the persons last name to appear. I know this must be
an easy formula, but I just cannot figure it out.

I appreciate your help.

 

[Guest]

=RIGHT(L1,FIND(" ",L1))

 

[Chip Pearson]

=RIGHT(L1,FIND(" ",L1))

That won't work. If, for example, L1 contains "abc defghi", that formula
will return the right 4 characters, not the text to the right of the space
character.

Instead, try

=MID(L1,FIND(" ",L1,1)+1,LEN(L1))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)