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