OK I went there but I didn't know how to use the wizard. I will figure it
out, I will not let this defeat me :) Thanks for your help

"paul" wrote:

check out the data menu;text to columns
--
paul

remove nospam for email addy!



"xwdpuzzler" wrote:

I have a Excel Spreadsheet that contacts both the names and addresses in the
same cell. I want to separate these to items making one cell for the name
and another for the street address, city, state, zip. Is there a way to do
this without having to redo the data by moving it to another cell one record
at a time.

Example:

-Before- -After-
Name Name Address City State Zip
Address

Thanks for any help.