software

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?

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 nicequot;Confused in Streatorquot; wrote:

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

Try Datagt;Text 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 lt;Confused in
gt; wrote:

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