separating text into separate columns


G

Guest

I'm new to Excel and working on a document with addresses in it. However, the first name and last name of the people are within the same column.

So my question is: how do you separate text into separate columns without having to delete it? For example, my text currently looks like this: "Jones, James" but I want Jones to be in a separate column (titled "LAST") and James (titled "FIRST") to be in a separate column.

Help? Thanks!
 
Ad

Advertisements

K

Ken Wright

With a blank column to the right of the column containing your data, select teh
column with the names and do Data / Text To Columns / Delimited / Space as
delimiter

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



Aisling said:
I'm new to Excel and working on a document with addresses in it. However, the
first name and last name of the people are within the same column.
So my question is: how do you separate text into separate columns without
having to delete it? For example, my text currently looks like this: "Jones,
James" but I want Jones to be in a separate column (titled "LAST") and James
(titled "FIRST") to be in a separate column.
 
G

Guest

Thank you Ken - of all the the helpful hints on how to do this - your way is the best.
 
Ad

Advertisements

K

Ken Wright

LOL - In this instance maybe - It's horses for courses really, as all ways are
useful deepnding on the circumstances.

One point though, I have no idea what thread you are referring to, though I can
guess the posts, so it is always best to stick to your original thread as it is
easy to see what you are referring to that way :)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



Shirley Birenz said:
Thank you Ken - of all the the helpful hints on how to do this - your way is
the best.
 
Ad

Advertisements


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

Top