Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace dot with commas
Dear Friends, does any of you has any piece of VB code that replaces dots with comma in a txt file? Thank you, G -- banava ----------------------------------------------------------------------- banavas's Profile: http://www.excelforum.com/member.php...fo&userid=1025 View this thread: http://www.excelforum.com/showthread.php?threadid=26880 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace dot with commas
Hi
why not use a text editor and do it outside excel? "banavas" wrote: Dear Friends, does any of you has any piece of VB code that replaces dots with commas in a txt file? Thank you, G. -- banavas ------------------------------------------------------------------------ banavas's Profile: http://www.excelforum.com/member.php...o&userid=10259 View this thread: http://www.excelforum.com/showthread...hreadid=268806 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace dot with commas
Banavas, Hi. A simple macro will do it. 'change selection to suit Columns("C:C").Select Selection.Replace What:=".", Replacement:=",", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False _ ReplaceFormat:=False cheers Koal -- koal ----------------------------------------------------------------------- koala's Profile: http://www.excelforum.com/member.php...fo&userid=1295 View this thread: http://www.excelforum.com/showthread.php?threadid=26880 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
So many commas | Excel Worksheet Functions | |||
Excel - Find and Replace from rows to separation by commas | Excel Discussion (Misc queries) | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Removing commas | Excel Worksheet Functions | |||
Replacing Tab with commas | Excel Programming |