How to create a formula to remove multiple . in a numbers?

  • Thread starter Thread starter Cheri.l
  • Start date Start date
C

Cheri.l

Ex: 11.2101.1030.0000.0000.1982 how can I remove these dots in multiple
numbers on a spreadsheet?
 
If you really mean a formula, meaning you will retain the dotted values and
display the number without the dots in another cell, then use this
formula...

=SUBSTITUTE(A1,".","")

If, on the other hand, you are trying to modify each cell's value in place,
then you can use Edit/Replace from Excel's menu bar... put a dot in the
"Find what" field and leave the "Replace with" field blank (empty).
 
Cheri.l said:
Ex: 11.2101.1030.0000.0000.1982 how can I remove these dots in multiple
numbers on a spreadsheet?
Click to expand...

You can remove the "dots" with SUBSTITUTE:

=SUBSTITUTE(A1,".","")

The result is still text that looks like a number, but due to the length of the
string, it isn't going to be much good as a number, anyway.
 
Back
Top