converting name through excel spreadsheet?

Question

i have an excel worksheet with 56000 name in each line; each cell format like Harris, Bob; what is the quickest way to swap first name and last name so it look like Bob Harris in the cell;

Answer 1

If "Harris, Bob" is in cell A1, then paste the following formula's

In B1;
=FIND(",",A1,1)

In C1;
=MID(A1,B1+2,LEN(A1)-B1-1)&" "&LEFT(A1,B1-1)

Highlight the range B1:C56000 and press +D to copy down.

Answer 2

That's a tricky one.

I would probably save it as a text file. Then I'd "import" it back into excel as a "comma delimited" text file, and the two names would then be in different fields. From there, you could sort it by first name.

Not sure how to otherwise do it without retyping everything.

Answer 3

Sorry, none that I know of.