Separating Names in a Column to Two Columns

D

donniebrook

I need to export a great deal of data, where the last and first names need to
exist in two separate columns, i.e.,
Doe, Jane to Doe Jane

Is there any way to accomplish without retyping?

Thanks,
D
 
N

Niek Otten

Look at Data>Text to columns in the main menu

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Top