How do I remove dots in a cell?

[mackao]

Hey.

I have a small problem, in a workbook I have several cells that looks like this 01.5564.2135.113
My problem is that I want to remove all the dots so that it looks like this: 0155642135113
What makes it even more complicated is that the dots are in different places in every cells.

It doesn't matter if the solution to the problem is to write a formula or a macro.

Thank you in advance
Mackao

 

[SteveO59L]

Edit, Replace

 

[mackao]

The thing is that the workbook contains 26300 different cells

 

[VoG]

Edit > Replace, replace . with nothing?

Or if you are looking for a formula

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

 

[mackao]

what is wrong if the formula don´t work?
I have the 2003 edition

 

[VoG]

What was the result of the formula?

 

[mackao]

Dear VoG

Excel says that something is wrong with the formula

 

[VoG]

If you are using a non-English version of Excel where , is used as the decimal separator then you will need to amend the formula to

=SUBSTITUTE(A1;".";"")

 

[mackao]

Sorry, now it works. It's like we say in Sweden, Crap behind the desk.

Thank you very much for your help

 

[MrMonkey95]

If you are using a non-English version of Excel where , is used as the decimal separator then you will need to amend the formula to

=SUBSTITUTE(A1;".";"")

can u gv toturial for me ?? please ... ~~
i need please so hard ~~~