Hi I'm using the following code that replaces within a formula any text following "cleaner*[...]" (i.e. cleaner*Sheet1!B2) so would like to consider the whole string as the string to be replaced. Normally the formalua also has other contents.

Cells.Replace What:="cleaner*", Replacement:="", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False

Is that possible?