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

Ex: 11.2101.1030.0000.0000.1982 how can I remove these dots in multiple
numbers on a spreadsheet?

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

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).

--
Rick (MVP - Excel)



"Cheri.l" wrote in message
...
Ex: 11.2101.1030.0000.0000.1982 how can I remove these dots in multiple
numbers on a spreadsheet?

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

Cheri.l wrote:
Ex: 11.2101.1030.0000.0000.1982 how can I remove these dots in multiple
numbers on a spreadsheet?

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.