Replace comma to dot

[Avadivelan TCS]

Hi All,
I want to replce the character from "comma(,) to dot(.)" .But if the ONE
particular cell (like A1) contains more than 200
entires in the same cell (A1-> 1234, 4567, 7895,.. etc) means , at that time
it will not work, it
says "Formula is too long" .
Please give a suggesstion in this case. Thanks in advance for your reply.

 

[Gary''s Student]

Find/Replace seems to have a problem. If you select a cell and run:

Sub fixit()
Dim s As String
s = Replace(Selection.Value, ",", ".")
Selection.Offset(1, 0).Value = s
End Sub

the updated text will be placed in the cell below the one you selected.