software

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

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

quot;Amyquot; wrote:

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

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

gt;I have cells that contains first name, last name, street address, city,
gt;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

One way:

Choose Data/Text to Columns...

In article gt;,
Amy gt; wrote:

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