| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| how do i seperate data from one column into two seperate ones in . | Excel Discussion (Misc queries) | |||
| merge data from multiple columns to single column | Excel Worksheet Functions | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Hybrid Mode
