Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
How do I split a single cell of data into multiple cells, when it is a
continous text string without delimiter characters? I want each single charcter of the string in its own cell. I am importing an ascii file and can separate the data manually during importi, using the fixed width, delimiter function, but it makes me manually place the seperator bar between each character. I could have up to 511 character text string so this is a bit tedious, and there doesn't seem to be hot keys to do this, so a Macro doesn't seem possible. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can I split one cell's data into two cells? | Excel Worksheet Functions | |||
Adding up data in multiple cells for a single criteria. | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions |