Name Format Formula

's Computer Specifications

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.

's Computer Specifications

Try

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

--

HTH

Bob

"sross002" <(E-Mail Removed)> wrote in message
news:AD3D64C2-D09E-4E72-909E-(E-Mail Removed)...
>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.

's Computer Specifications

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
>
> Thank You in advance.

's Computer Specifications

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
>
> Thank You in advance.

's Computer Specifications

Thank You!

"Bob Phillips" wrote:

> Try
>
> =MID(A1,FIND(" ",A1)+1,99)&", "&LEFT(A1,1)
>
> --
>
> HTH
>
> Bob
>
> "sross002" <(E-Mail Removed)> wrote in message
> news:AD3D64C2-D09E-4E72-909E-(E-Mail Removed)...
> >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
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: creating last name first, first name last from a column of first name last name data	Rick Rothstein	Microsoft Excel Programming	0	27th Jul 2009 07:25 AM
1st name last name to last name, 1st name	shan	Microsoft Excel Worksheet Functions	2	11th Mar 2009 07:59 PM
change first name last name to last name first name	Doris smith	Microsoft Excel Misc	3	25th Feb 2009 12:35 PM
how do I reveerse name order last name, first name to first name, last name	Don Smith	Microsoft Excel Discussion	9	29th Nov 2006 10:55 PM
Changing a list from last name, first name to first name, last name	zgall1	Microsoft Excel Misc	3	17th Feb 2006 12:49 AM