View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Miguel Zapico
 
Posts: n/a
Default 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?