Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|