Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reverse Concatenation (Splitting Single Cell Data into Multiple Ce
Good Sirs & Madams:
Please help me with my excel question. Thank you in advance. 1002bat 2003cat 3009dog 4005frog 5003snake I want to take single cell data and split the contents into multiple cells. "1002bat" would become "100", "2", "Bat". The way our information is "imported" into excel results in the concatenation of data that would be useful to be split. Is there a macro that can take the first "x" digits/text" of a long string in order to accomplish this separation. Thanks, Sir Eric (Queen's Knight) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REVERSE SINGLE CELL TEXT STRING | Excel Worksheet Functions | |||
Splitting data in a single cell that is seperated by commas, then moving to make individual rows | Excel Discussion (Misc queries) | |||
Splitting data out of a single cell | Excel Discussion (Misc queries) | |||
Splitting single column data into two | Excel Worksheet Functions | |||
Splitting a single cell | Excel Discussion (Misc queries) |