minus first word in column
 

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.

minus first word in column
 

=RIGHT(L1,FIND(" ",L1))
--
Gary''s Student
gsnu200709


"Cathy" wrote:

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.

minus first word in column
 

"Gary''s Student" wrote in message

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

"Gary''s Student" wrote in message
...
=RIGHT(L1,FIND(" ",L1))
--
Gary''s Student
gsnu200709


"Cathy" wrote:

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.