want to replcae from"comma(,)" to "dot(.)
 

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.

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.