RE:PUNTOS Y COMAS DE NUEVO
puedes usar la funcion REPLACE en VBA
Replace(expresión, encontrar, reemplazarCon [, inicio[, contar[, comparar]]])
o usas el metodo replace para cambios directos en una hoja
expresión.Replace(What, Replacement, LookAt, SearchOrder, MatchCase, MatchByte, SearchFormat, ReplaceFormat)
Ej
Worksheets("Sheet1").Columns("A").Replace _
What:="SIN", Replacement:="COS", _
SearchOrder:=xlByColumns, MatchCase:=True
otro ejemp
Sub UseReplace()
Dim strCurrent As String
Dim strReplaced As String
strCurrent = "abcdef"
' Notify user and display current string.
MsgBox "The current string is: " & strCurrent
' Replace "cd" with "-".
strReplaced = Application.WorksheetFunction.Replace _
(Arg1:=strCurrent, Arg2:=3, _
Arg3:=2, Arg4:="-")
' Notify user and display replaced string.
MsgBox "The replaced string is: " & strReplaced
End Sub