Forum Discussion
search and replace form "." to ","
Hello I'm a new one in this community. My problem is that I want to do "search and replace" from "." to "," I have a database of about 360,000 personal records in one file. In my new file I use as...
Hello Ivo1954,
Without knowing the format of your worksheet, it would be difficult to provide a truly proper answer. However, as a general answer, the following formula would change a number in the format 0.00.00 to 0.00,00:
=REPLACE(A1,LEN(A1)-2,1,",")
I hope this helps!
Ivo, is the data like
Froek Zwarthoed(name) 38.97 1.18.06 1.59.56 4.18.74 7.24.47 15.38.88
in one cell as text or these are separate cells like
It's one cell.
The Second "." must be "'" 1.18.06 to 1.18,06.
And not only this speed skater but in 60.000 speed skaters with around an average of 360.000 cells...
Changing each cell is not possible...
I see, thank you. One more to clarify - do I understand correctly that could be one or two dots in each "number", not always only two?
