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

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

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