Sorting names

  • Thread starter Thread starter formatter
  • Start date Start date
F

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.
 
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
 
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





.
Click to expand...
 
Back
Top