I have some data that I pasted into excel and then used text to
columns to return the data to columns of data. That's fine but one of
the colums contains values and these have unwanted spaces and are
being formated as text rather than numbers e.g. -1.074 552 982 e-26.
The spaces do not occur in the same position in each value and many
values have more than one space. There's a lot of data and so how can
I remove these unwanted spaces?

Many thanks for any help.

--
Nige Danton