Hi Nige,

Look at the TRIM() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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
|