Replace comma to dot

G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top