separating text into separate columns

[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!

 

[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
----------------------------------------------------------------------------

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.

 

[Guest]

Thank you so much!

 

[Ken Wright]

You're welcome

 

[Guest]

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

 

[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
----------------------------------------------------------------------------

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

the best.