remove unwanted spaces?

[Nige Danton]

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.

 

[Niek Otten]

Hi Nige,

Look at the TRIM() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

 

[Nige Danton]

Hi Nige,

Look at the TRIM() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

Hi, Many thanks for your help. I've tried the trim function but that
still leaves single spaces in the numbers e.g. original data was "
3.015 500 7134 e-3" and after trim is "3.015 500 7134 e-3" In this
example how do I delete the remaining three spaces? Thanks again.

 

[Arvi Laanemets]

Hi

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

 

[Nige Danton]

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

Bingo! Thanks everybody.

 

[Fred Smith]

Use Substitute. Substitute "" for " ".