Excel >> creating last name first, first name last from a column of first name last name data

by JasonK » Mon, 27 Jul 2009 13:57:01 GMT



I can't figure for the life of me how the make a column of names
formatted:

FirstName LastName

into

LastName, FirstName


I'm sure there is an easy formula to copy or macro to write.

can someone help me with this?

thanks a ton, in advance. I'm appreciate your help.

JasonK



Excel >> creating last name first, first name last from a column of first name last name data

by Rick Rothstein » Mon, 27 Jul 2009 14:25:08 GMT


Give this formula a try...

=MID(A2&", "&A2,FIND(" ",A2)+1,LEN(A2)+1)

Change the A2 to the cell address of the cell containing your first set of
names and then copy it down.

--
Rick (MVP - Excel)

Excel >> creating last name first, first name last from a column of first name last name data

by Lars-e Aspelin » Mon, 27 Jul 2009 14:32:30 GMT


Assuming that FirstName and LastName is separated by one space and
that they don't have any spaces within them, try the following
formula:

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

If FirstName and/or LastName can have spaces, e.g. double names, you
have to give additional information on how to decide which parts
belong to FirstName and LastName.

Hope this helps / Lars-e

Excel >> creating last name first, first name last from a column of first name last name data

by Patrick Molloy » Mon, 27 Jul 2009 15:17:57 GMT

select the column , use Edit, Find, Replace and in the Find What box type a
space and in the Replace with box type a comma and a space

Excel >> creating last name first, first name last from a column of first name last name data

by JasonK » Tue, 28 Jul 2009 13:26:00 GMT

thank you -- worked perfectly
jasonK



On Mon, 27 Jul 2009 02:25:08 -0400, "Rick Rothstein"

Similar Threads

1. how do I reveerse name order last name, first name to first name, last name

I have a long database, 27k with names that I want to mail to.  The
list is last name, first name.  I want to do a global change to first
name, last name.  I also want to add "Mr" to it.  For example:  the
list now is Smith, John.  I want to change it to Mr. John Smith for
the entire list.

2. change first name last name to last name first name - Excel

3. Changing a list from last name, first name to first name, last name

4. I need to swap last name, first name in a cell to first name last - Excel Functions&Formulas

5. last name first, first name last -- is there a code to combine 2 c

If you need both formats, why don'tyou use two helper columns, say D with 
formula
=B2&", "&C2
and E with formula
=C2&" "&B2
filled down as necessary?

Regards,
Stefi

asonKezt rta:

>> Thanks again for all your help.  This group has been quite valuable to
>> me.
>> 
>> There are a couple of things I would like to do here.
>> 
>> First, I have two columns of data. Col B is last names, Col C is first
>> names.  I would like to combine all that data into Col B with the Last
>> Name First, (comma space) then First Name.
>> 
>> Is there a quick macro I can write to do that?
>> 
>> Then, after the data is in that format, is there a way to reverse
>> column B so that the data is First Name First (space) Last Name (no
>> comma)?
>> 
>> That would be the best.  I need the data both ways at different times
>> depending on what I'm doing.
>> 
>> Thanks again in advance for the advice.
>> 
>> JasonK
>> 
>> 
>> 

6. last name first, first name last -- is there a code to combine - Excel

7. Sort 2 lists - one w/ last, first name // one w/ first, last name

I have 2 very large excel files that have pulled employee name, week ending 
and hours information.  The information comes from 2 different systems.  As a 
result, the names are not input the same way.  I need to combine both lists 
and make sure that they mirror one another.   Is that possible using a macro 
or sorting by "matching"?  
Ex.  AGARWAL NIMISH, 10/1/2004, 20 hours // NIMISH R AGARWAL,10/1/2004, 20 
hours	

8. Last name first first name last - Excel Functions&Formulas