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