Why not enter them in separate cells to begin with, the use the sum function
to add them up. Then you won't need to separate them.

--
Regards,
Tom Ogilvy

"2007-User" wrote in message
...
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.