minus first word in column

C

Cathy

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.
 
C

Chip Pearson

Gary''s Student said:
=RIGHT(L1,FIND(" ",L1))
Click to expand...

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)
 
Top