| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
text in new cells
Even better.
Regards, Alan "T. Valko" wrote in message ... Select your data Goto the menu DataText to Columns DelimitedNextCommaFinish Biff "Harrison" wrote in message ... hi all... i have a bunch of data that was given to me all run together, but is seperated by commas, for example: 642, 758, 25895, 245, 755, 4444, and so on i am wondering if there is any way to take all this data and put each piece in a seperate cell, the only way i have thought of is to copy and paste each data entry, but when you get up to at least 200 sets of data, that becomes impractical. any help would be greatly appreciated. thanks for your time --Harrison-- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
| merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
| In Excel, option to enter text in cells the same as text boxes | Excel Worksheet Functions | |||
| Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
| How to input additional text to multiple of existing cells that has text | Excel Worksheet Functions | |||
Threaded Mode
