how can i remove all spaces in a number

R

Rick Rothstein \(MVP - VB\)

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
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I remove blank spaces from fields 6
How do you remove trailing spaces withour Trim function? 8
How can i remove spaces? 1
Formula to convert a number with spaces to just a number? 10
How do I remove leading spaces the column is left justified 3
Macro to remove trailing spaces in cells 2
format to a specific number of spaces 2
How do I remove spaces 5

Top