want to replcae from"comma(,)" to "dot(.)
Try in B1:
=SUBSTITUTE(A1,",",".")
and copy down
Copy/Paste Special/values
HTH
"Avadivelan TCS" wrote:
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.
|