Delete Cell value if it contains any text in Excel

[oldb]

Hi,

I need to delete cell values if they contain any text on multiple spreadsheets (but not all, every sheet after the 5th one).
Range would be E3 to GW16 on every sheet.

Is there an easy way to do this?
Thanks for your help

 

[oldb]

Re: "if they contain any text"
What is considered any text?

1234abcd567
or
abcdef
or
ghij klmn 987
or
1234 formatted as text

good question... now that I think about it, it may be better if it would just show in which cell on what sheet text is, so not deleting it but only tell me where it is. In this case any of those except the last one would be nice to know.

 

[Peter_SSs]

Thanks Peter this seems to work perfectly

You're welcome. Thanks for the follow-up.

 

[Peter_SSs]

it may be better if it would just show in which cell on what sheet text is,

This would highlight them yellow instead of deleting

Sub Highlight_Text_Values()
  Dim i As Long
  
  On Error Resume Next
  For i = 6 To Sheets.Count
    Sheets(i).Range("E3:GW16").SpecialCells(xlCellTypeConstants, xlTextValues).Interior.Color = vbYellow
  Next i
  On Error GoTo 0
End Sub