minus first word in column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cathy - 07 Mar 2007 00:03 GMT

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.

Reply to this Message

Gary''s Student - 07 Mar 2007 00:09 GMT

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

Signature

Gary''s Student
gsnu200709

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

Reply to this Message

Chip Pearson - 07 Mar 2007 00:20 GMT

"Gary''s Student" <GarysStudent@discussions.microsoft.com> 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))

Signature

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

> =RIGHT(L1,FIND(" ",L1))
>
[quoted text clipped - 5 lines]
>>
>> I appreciate your help.

Reply to this Message