How to remove dot(s) .. or ... in front of text string, not in a middle

Hello All,
I'm loking for code to remove two dot or three dot in front of text string but not single dot in middle. If I use replace then it remove all dot.

Exp:

..123 => 123
..abc => abc
...456 => 456
...def => def
123.456 => 123.456
...123.456 => 123.456
..abc.123 => abc.123
456789 => 456789

Regards,
tt3

i think you need another . in there
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(".."&A1,".....",""),"....",""),"...",""),"..","")
otherwise if there is no leading . it adds one
eg
456789 => 456789
becomes
.456789 => 456789

THis may be a long way round, but maybe Text-to-Columns, and then re-combine those that you need to be combined?

Thank you very much for all your help,
@FD: I prefer Macro
@Peter: it work and also create extra (.) at blank cell (but also delete 0 in front)
@John & Martin: it work (but also delete 0 in front)
let says: ..0448123 => 448123 and how to keep 0 in front?

Regards,
tt3

doesn't remove 0 when i do it

Hi Martin:
I was using the .value = .Value so it omitted the 0 infront .Now I use Paste Special then solved the problem. Thank you very much for all your time and help.

Regards,
tt3

@Martin,

Probably due to the cell's number format.