Macro to remove single commas

[inarbeth]

I want to strip out single commas from within text strings.

Cells.Replace What:=",,", Replacement:=" "

removes the double comma

I have tried:

Cells.Replace What:=",", Replacement:=" " and
Cells.Replace What:=Chr(44), Replacement:=Chr(32)

but the single commas refuse to budge. Is there a way to do this?

 

[JamesW]

Hi there,

Sub test()
    Dim e
    With ActiveSheet.UsedRange
        For Each e In [{","}]
            .Replace e, "", xlPart
        Next
    End With
End Sub

Source: http://www.mrexcel.com/forum/showthread.php?t=392357

 

[inarbeth]

Thank you James