Sorting names

[formatter]

I could not find an answer before posting so here an easy
(at least on the surface) question. I have a user who
created a column with 'lastname, firstname' format and
now needs 'firstname lastname'. Short of retyping the
entire column, is there an easier way? A formula perhaps?
Thanks in advance.

 

[Gord Dibben]

formatter

For formulas and a downloadable workbook, see Chip Pearson's First/Last page
at

http://www.cpearson.com/excel/FirstLast.htm

Gord Dibben Excel MVP

 

[CLR]

You could use Data > Text to columns, with comma as the delimiter to
separate the two names into two columns and then Concatenate them back
together in the proper order...........
like, =B1&A1

Vaya con Dios,
Chuck, CABGx3

 

[downloader]

Thank you for the help

-----Original Message-----
You could use Data > Text to columns, with comma as the delimiter to
separate the two names into two columns and then Concatenate them back
together in the proper order...........
like, =B1&A1

Vaya con Dios,
Chuck, CABGx3





.