How do I seperate data in one column into multi columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using two cells 1 with total time n 1 with date how can i put the. 2
variable in data validation 4
seperating data from one cell to multiple cells? 5
search function 2
Seperate info in a cell 13
matching & combining data from seperate worksheets 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Convert number to text as displayed 3

Back
Top