Delete spaces in cell content

[excelcandy]

A column contains a list of numbers which either have spaces between the numbers or are followed by a space. How do I delete all spaces from the selection A:A?

[alansidman]

This should help

http://www.extendoffice.com/document...ve-spaces.html

[Kaper]

Select column A
Ctrl+H
Search: one space here
Replace with: leave empty

PS. check if numbers are really numbers now (not texts which only look like numbers)

[excelcandy]

is that CTRL+F ? The normal replacement does not work, is there an alternative to delete spaces in all cells within a range of cells?

[Kaper]

Ctrl+H (like cHange, but Ctrl+C is used for other purpose :-P) should open directly second tab (change <=> replace) of Find dialog (Ctrl+F).

May be these characters are not spaces, but for instance non-breaking spaces (Alt160)? Quite often case in for instance data imported from financial documents.
if b1:
=SUBSTITUTE(A1,CHAR(160),"")
works with A1 then here we are.
easy way - copy formula all way down
then copy column B and paste special as values to column A

or use numeric keypad (keep left Alt pressed and type 0160 on numeric keypad, release Alt) to enter this non-breaking-space into search and replace dialog instead of normal space.