separating text into separate columns

  • Thread starter Thread starter Guest
  • Start date Start date
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!
 
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
Click to expand...
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
Click to expand...
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.
 
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
Click to expand...
the best.
 
Back
Top