How do I seperate data in one column into multi columns

  • Thread starter Confused in Streator
  • Start date
C

Confused in Streator

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?
 
M

Miguel Zapico

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

Gord Dibben

Try Data>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 <Confused in
 
Top