Hi

Select the range with data, from where you want remove ALL spaces.
Search 'Find what' - enter " " , 'Replace with' - remains empty Replace
All


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Nige Danton" wrote in message
...
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