Transpose data in cell

[Zenwood]

I have a list of names in column "N" that look like "LastName, FirstName". How to I switch the data in the cell so it looks like "FitstName LastName"?

 

[cooper645]

If you want an easy way,

use a helper column with the following formula (assuming your data starts in row 1)

this one inserts a Comma, if you wish just remove the comma and keep the space
=RIGHT(N1,FIND(",",N1,1)-2)&", "&LEFT(N1,FIND(",",N1,1)-1)

Then copy and paste the values back into column N or do as you please, maybe keep the helper column.

HTH Coops

 

[jtakw]

Hi,

Here's another way:

Book1
	A	B
1	LastName, FirstName	FirstName LastName
Sheet404

Cell Formulas
Range	Formula
B1	=MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1)

 

[Eric W]

If this is a one time thing, or even just a periodic thing that doesn't require a dynamic formula, you can use Flash Fill. Just type in the name as you want it to appear in the cell to the right of the original cell. Then with the selection in the same column just press Control+E, and it will figure out the rest of the column.

 

[Zenwood]

Thanks, that works.