excel number formats

New Contributor

I have a list of serial numbers  imported in an excel spreadsheet that have spaces in the numbers

ie 123 4567 678 

How can I format the column so the space is removed between the digits.

4 Replies


You may select the list, Ctrl+H and replace spaces on nothing

more information please


Select the cells from which you want to remove the spaces.

Press Ctrl+H to activate the Replace dialog.

Click in the 'find what' box and type a single space.

Leave the 'Replace with' box empty.

Click the 'Replace All' button.


Excel will tell you how many spaces were replaced.

Click OK, then close the Replace dialog.



@Hans Vogelaar , thanks!