Deleting Specific Text From Various Cells

**Chris Skittz** · 09-11-2008, 06:31 AM

Hey there people.

I'm in need of a script that deletes cells that contain the word "Unknown" which are present in several columns on my spreadsheet.

I don't want it to alter the other data in any way, just to clear the text from those cells.

Thanks, Chris.

**davesexcel** · 09-11-2008, 06:42 AM

Hi Chris,
The macro recorder works great for this
Hit Ctrl + H
for find and replace
here's what the code loks like.

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 9/11/2008 by Dave Morrison
'

'
    Cells.Replace What:="Unknown", Replacement:="", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
End Sub