How do I seperate data in one column into multi columns
 

I have a worksheet with mulitiple data put into one cell.
Is there away to seprate this data into multiple cells with out having to
retype it?

How do I seperate data in one column into multi columns
 

I would copy all the cells into a blank notepad, save it, and then open it
from Excel and follow the import text file wizard. It has an option to set
the column delimiter and it will do the split for you.
--
It is nice to be important, but it is more important to be nice


"Confused in Streator" wrote:

I have a worksheet with mulitiple data put into one cell.
Is there away to seprate this data into multiple cells with out having to
retype it?

How do I seperate data in one column into multi columns
 

Try DataText to Columns with some sort of de-limiter to break out the data to
seperate columns.

Space, comma, fixed width, something common?


Gord Dibben MS Excel MVP

On Fri, 3 Mar 2006 11:39:13 -0800, Confused in Streator <Confused in
wrote:

I have a worksheet with mulitiple data put into one cell.
Is there away to seprate this data into multiple cells with out having to
retype it?