Replace dot with commas

[banavas]

Dear Friends,

does any of you has any piece of VB code that replaces dots with comma
in a txt file?

Thank you,
G

 

[Guest]

Hi
why not use a text editor and do it outside excel?

 

[koala]

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