Macro to replace certain text

[bmoore45]

Hey guys

I'm looking for a way to delete any occurence of the letter 'o' in column G of my chart, does anyone know how I can do this?

Cheers,

ben

 

[Michael M]

Hmm, this will replace all instances of "o" in column "G:G", including formulae

Try it on a copy first !!

Sub Macro1()
    Columns("G:G").Replace What:="=", Replacement:="&", LookAt:=xlPart, _
        SearchOrder:=xlByColumns
    Columns("G:G").Replace What:="o", Replacement:="", LookAt:=xlPart, _
        SearchOrder:=xlByColumns
    Columns("G:G").Replace What:="&", Replacement:="=", LookAt:=xlPart, _
        SearchOrder:=xlByColumns
End Sub

 

[bmoore45]

TYVM! now why didn't I think of that...

 

[Michael M]

Glad it worked....thanks for the feedback