Removing Spaces

**jdomante** · 11-18-2009, 02:39 PM

I have a file with one column of numbers. All of the numbers have a space after the last digit. Which will not allow me to do what i want with the data. Is there anyway to automate the removal of the spaces?

**khamilton** · 11-18-2009, 02:55 PM

http://www.excelforum.com/excel-gene...haracters.html

**Huron** · 11-18-2009, 02:59 PM

Removed my post

**teylyn** · 11-18-2009, 03:54 PM

Alternative to Find & Replace suggested in the link:

Enter a 0 in a cell, any empty cell will do.
Copy the 0
Select your numbers with trailing spaces
Click Edit - Paste Special and tick the Add option
Hit OK

Viola. All cells are now numbers where before they were text.

PS @ Huron, no need to retract a post just because you think someone else's is better. Ultimately, it's the OP who decides which solution is "best". But that depends on such a lot of things that I find it useful to choose from as many alternatives as possible. So, why not put it back?

**Huron** · 11-18-2009, 04:32 PM

My suggestion was to enter the formula

=VALUE(TRIM(A1))

into another column (assuming the numbers are in column A), copy this down, then copy and Paste Special - Values over the original numbers.

This is a lot slower than the Find / Replace method.