Name Format Formula

sross002
Guest
Posts: n/a

 5th Apr 2010
I have a full name in A1 but I want it to read as: Full Last Name, First
Name Initial.

For example, I would like to convert John Appleseed (a1) to Appleseed, J

Bob Phillips
Guest
Posts: n/a

 5th Apr 2010
Try

=MID(A1,FIND(" ",A1)+1,99)&", "&LEFT(A1,1)

--

HTH

Bob

"sross002" <(E-Mail Removed)> wrote in message
>I have a full name in A1 but I want it to read as: Full Last Name, First
> Name Initial.
>
> For example, I would like to convert John Appleseed (a1) to Appleseed, J
>

Paul C
Guest
Posts: n/a

 5th Apr 2010
Use

=RIGHT(A1,LEN(A1)-FIND(" ",A1)) &", " & LEFT(A1,1)

This assumes only one space inbetween first and last name.

--
If this helps, please remember to click yes.

"sross002" wrote:

> I have a full name in A1 but I want it to read as: Full Last Name, First
> Name Initial.
>
> For example, I would like to convert John Appleseed (a1) to Appleseed, J
>

JLatham
Guest
Posts: n/a

 5th Apr 2010
Handles 1 or 2 spaces, so can deal with
John Appleseed or John X. Appleseed
both result in Appleseed, J

Thanks to Paul C for giving me the one-space solution to toss in with my
2-space solution.

"sross002" wrote:

> I have a full name in A1 but I want it to read as: Full Last Name, First
> Name Initial.
>
> For example, I would like to convert John Appleseed (a1) to Appleseed, J
>

sross002
Guest
Posts: n/a

 6th Apr 2010
Thank You!

"Bob Phillips" wrote:

> Try
>
> =MID(A1,FIND(" ",A1)+1,99)&", "&LEFT(A1,1)
>
> --
>
> HTH
>
> Bob
>
> "sross002" <(E-Mail Removed)> wrote in message
> >I have a full name in A1 but I want it to read as: Full Last Name, First
> > Name Initial.
> >
> > For example, I would like to convert John Appleseed (a1) to Appleseed, J
> >
> > Thank You in advance.

>
>
> .
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Rick Rothstein Microsoft Excel Programming 0 27th Jul 2009 07:25 AM shan Microsoft Excel Worksheet Functions 2 11th Mar 2009 07:59 PM Doris smith Microsoft Excel Misc 3 25th Feb 2009 12:35 PM Don Smith Microsoft Excel Discussion 9 29th Nov 2006 10:55 PM zgall1 Microsoft Excel Misc 3 17th Feb 2006 12:49 AM

Features