Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Seperating Numbers
Hi,
This is an example of what I am trying to do: In one cell I have "=4+6+12+18+4+5+8+7" (so the result of this cell would be "64"). Now, I would like to have all of these numbers to be sorted and separated in one row (or column) next to each other (like "4","6","12", ... Etc.) how is this possible with or without using VBA? Thanks for your future inputs. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seperating Text from Numbers in a cell | Excel Worksheet Functions | |||
excel, seperating numbers and text, macro | Excel Discussion (Misc queries) | |||
Seperating numbers from text | Excel Discussion (Misc queries) | |||
Seperating First and Last Names | Excel Discussion (Misc queries) | |||
Seperating Numbers from Letters in Excel | Excel Worksheet Functions |