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