Separating Names in a Column to Two Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Data>Text to columns in the main menu

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pull out Last Name 8
Combine multiple columns and rows for one record into one row. 2
Bringing to a cell the last date an event occurred 6
Filer for unique records and return all column data for unique rec 1
concatenate 2 columns (A2+B2) and compare for duplicates 3
text to columns 1
How to Remove dup names and if same rate. 3
Please help. Remove dups automaic of same name,price,month. 6

Back
Top