VBA Macro: Find value in Column F and Replace

[harky]

I want to find "" in Column F and replace with ""

 

[JackDanIce]

Try recording a macro and reviewing the resulting code

 

[harky]

Can't because there are thousand data.

It find

"poster//"
With
"poster/"

 

[harky]

It find

"poster//"
With
"poster/"

 

[JackDanIce]

Try:

Sub Replace()

    Range("F:F").Replace "poster//", "poster/", xlPart, xlByColumns, True
    
End Sub

 

[harky]

thx u so much. work wonder

Try:

Sub Replace()

    Range("F:F").Replace "poster//", "poster/", xlPart, xlByColumns, True
    
End Sub

 

[JackDanIce]

You're welcome, glad it's resolved