| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i split data into individual cells
notepad file "open with" microsoft excel resulted in all data lumping into
one cell. Hence, is there any way i can split those strings of data into each individual line. i can provide files if needed. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do i split data into individual cells
Hi Kelly
Select column ADataText to columnsDelimitedselect delimiterFinish It is probable that you will need tab or space as the delimiter. -- Regards Roger Govier "Kelly" wrote in message ... notepad file "open with" microsoft excel resulted in all data lumping into one cell. Hence, is there any way i can split those strings of data into each individual line. i can provide files if needed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is it only appropriate to insert *different* data into *individual* cells... | Excel Discussion (Misc queries) | |||
| Extracting Comma Seperated data into individual Cells | Excel Discussion (Misc queries) | |||
| Split numerical vales joinned by && into individual rows | Excel Discussion (Misc queries) | |||
| Can I split worksheets from one workbook into individual workbooks | Excel Discussion (Misc queries) | |||
| How do I merge individual data now in multiple cells, in to one b. | Excel Worksheet Functions | |||
Linear Mode
