Separating Names in a Column to Two Columns
 

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

Look at DataText to columns in the main menu

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"donniebrook" wrote in message
...
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