Thanks,but do I have to do this every time I create such Cell? I mean, this
is a routine calculation that I should do, I have to enter all of those
numbers in one cell but at the same time, I need a procedure that can divide
them( as I explained or you explained ...) so I can do another type of
calculations base on each numbers.


"Gary''s Student" wrote in message
...
You don't need VBA for this. But it does take several steps:

1. use Data Text to Columns... with the plus sign as the separator
2. use Copy/PasteSpecial as transpose to copy the row of data into a
column
4. sort the column
5. use copy/PasteSpecial as transpose to copy the column back into the
row.
--
Gary's Student


"2007-User" wrote:

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.