Need Empty Cell: MACRO.......plz help

[omegadeltaphi]

I have a string of "xxxxxxxxxxxxxx" in Worksheet. Need to simply empty those cells entirely, don't need them. Empty not Delete the cells that contain 14 or more x's: xxxxxxxxxxxxxx

4 columns
thousands of rows

the strings of "xxxxxxxxxxxxxx" is literally 14 x's or more sometimes with information in front of and in back of like so:

tx 75228 xxxxxxxxxxxxxx 00xxxxxxxxxxxxxx
infoxxxxxxxxxxxxxx $xxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxx


Steve G
thanks in advance

 

[wigi]

Sub replaceXes()

    Columns("A:D").Replace String(14, "x"), "", xlPart

End Sub

Please provide a descriptive topic title for threads in the future. This one is clearly inadequate for all search operations.

 

[omegadeltaphi]

this did not work, and what would you have recommended i state for a descriptive title. i am not savvy in excel nor explanations or jargon so please help me with that title and what you would have named it because i will be posting more questions?

thanks,
Steve

I still need a solution for the Macro anyone????

 

[wigi]

For instance: "Remove character x from cells"

Please post a representative sample of your data, not just typing a few lines.
Also, state the requested output in a clear way.

It would help to describe what is not working on the macro. Only saying "this did not work" will not bring us to a solution quickly.

 

[Rick Rothstein]

I think this macro will do what you want...

Sub Remove14orMoreXs()
  Columns("A:D").Replace "*xxxxxxxxxxxxxx*", "", xlWhole
End Sub

 

[omegadeltaphi]

Rick
Thx man that worked!!!!

Steve

Wigi
thx bro