split text column

  • Thread starter Thread starter Louie
  • Start date Start date
L

Louie

I have a name column that contains both first and last names. Is there a way
to split this column to make two columns, one for first name and one for
last name?
Thanks for any help.
 
Hi Louie,

Try Data | Text to Columns

HTH

Kevin

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

moving first word in a column to a separate column 8
why won't text-to-columns work here? 6
Excel Comparing two columns 1
Split column contents (de-concantenate) 7
Too Clever... 2
Excel Newb: Splitting First name and Last name 1
Dividing text 6
Conditional searching 1

Back
Top