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

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)


"JasonK" wrote in message
...


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

On Sun, 26 Jul 2009 22:57:01 -0700, JasonK wrote:



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


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-Åke

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

"JasonK" wrote in message
...


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

thank you -- worked perfectly
jasonK



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

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.