search and replace with wild characters as LITERALS

Question

i am trying to search for [Panels] like "*,*"

within a worksheet and unfortunately instead of retrieving exactly that string it retrieves anything like:

[Panels] like "*blah,*"
[Panels] like "*blah,123123*"

i need it to be EXACTLY [Panels] like "*,*"

and i suppose that perhaps i would to do this in VBA instead of manually? if this is not possible to do manually how would i do a search and replace a different way?

Answer 1

Tilde (~) escapes *, ?, and ~ in Excel's find and replace.

[Panels] like "~*blah,~*"