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.