Reverse concatenate
 

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

Reverse concatenate
 

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

"Amy" wrote:

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

Reverse concatenate
 

On Wed, 5 Apr 2006 06:36:02 -0700, Amy wrote:

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

Reverse concatenate
 

One way:

Choose Data/Text to Columns...

In article ,
Amy wrote:

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