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

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
|

On Dec 7, 4:49 pm, "Niek Otten" wrote:
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.

--
Nige Danton

Use Substitute. Substitute "" for " ".

--
Regards,
Fred


"Nige Danton" wrote in message
...
On Dec 7, 4:49 pm, "Niek Otten" wrote:
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.

--
Nige Danton

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

On Dec 7, 5:23 pm, "Arvi Laanemets" wrote:
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.

--
Nige Danton