Reverse concatenate

[Amy]

I have cells that contains first name, last name, street address, city,
state, and zip. How do I seperate these into seperate columns.

 

[Toppers]

Look at Data==>Text to Columns or use VBA with SPLIT function. How are the
fields delimited?

 

[Ron Rosenfeld]

I have cells that contains first name, last name, street address, city,
state, and zip. How do I seperate these into seperate columns.

If the fields are separated by commas, you can use the Data/Text-to-Columns
wizard specifying comma as the delimiter.


--ron

 

[JE McGimpsey]

One way:

Choose Data/Text to Columns...