how can i remove all spaces in a number

  • Thread starter Thread starter allahyari
  • Start date Start date
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
 
If you have a range of these to fix, you could:
Select the range
edit|replace
what: (spacebar)
with: (leave blank)
replace all
 
You must log in or register to reply here.

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
Removing number spacing in cells 4
Space removal - a first name,space last name 2
Removing Space 7
Removing spaces from middle of cell 5
Format number 2
removing all spaces 4

Back
Top