how can i remove all spaces in a number
 

how can i remove all spaces in a number

how can i remove all spaces in a number
 

how can i remove all spaces in a number

This will remove all spaces from the value in A1 whether it's a number or
not...

=SUBSTITUTE(A1," ","")

Rick

how can i remove all spaces in a number
 

If you have a range of these to fix, you could:
Select the range
edit|replace
what: (spacebar)
with: (leave blank)
replace all



allahyari wrote:

how can i remove all spaces in a number

--

Dave Peterson