Try TRIM function.

for example you have some value in A1. In B1 enter =TRIM(A1)


"Marianne" wrote in message
...
When I download statistical information from a specific source, there are
spaces in the cells (either first or in between the numbers), and the
numbers
are not interpreted as numbers. How can I easily delete all spaces instead
of
entering each cell and doing it manually?