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?

"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.

[Ron Rosenfeld]

On Wed, 5 Apr 2006 06:36:02 -0700, Amy <Amy@discussions.microsoft.com> 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

[JE McGimpsey]

One way:

Choose Data/Text to Columns...

In article <DE9071B7-34F0-4B90-80A3-E3F71FD26C25@microsoft.com>,
Amy <Amy@discussions.microsoft.com> wrote:

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