How much more automatic can you expect? It takes about 5 seconds to do an
entire list this way. There are no formulas, no copying and pasting values.
Find and Replace is usually the desired way to go, if you can do it.

Data text to columns will also take apart the cells. Just make sure there
is nothing to the right of the cells, and then select Data-Text to columns.
Then select delimited and choose "space" as your delimiter. After it's done,
just delete all the columns except the first one. If you paste as text after
you have done this once on an open document, it will split the cells
automatically. You still have to delete the cells containing text though.

"emerald" wrote:

Kostis
I get "A value used in the formula is of the wrong data type."

Ron
<<Does that help?
Not really - it misses the 'Automatically' bit :-)