Hej,
I need your help please. I have data from a .csv file where unluckily the decimal and the thousand symbol are both ".". Therefore I would like to remove all "." except for the last one, which is the actual decimal-dot.
As a formula I use: =IF((LEN(A1)-LEN(SUBSTITUTE(A1,".",""))>1),SUBSTITUTE(A1,".","",1),A1), but this only gives me the possibility to change the first ".". I would prefer to exchange all except for the last one. Also I would prefer to let it run as a macro, but there I'm stuck. I don't find a proper starting point. I think I need to count the amount of "." in each cell and if this amount is >1, I should replace them by "".
But I don't know how to express it. Can somebody please help me?
Thanks a lot!
Greetings
Moni
Bookmarks