I have some part numbers in string format that include the caret (^)
symbol.

For instance: ^^^235-741-22 STAINLESS STEEL NUT

I would like to get rid of the "^" symbol in the string, so that the
part number would be:

235-741-22 STAILESS STEEL NUT

but Excel's Search and Replace does not let me search and replace using
"^^^" (without quotes). It thinks that it is some kind of formula.

I tried putting a tilde (~), an ampersand (&), or just a single quote
(') in front of the search string (ex.: ~^^^) but Excel still does not
like it.

What is the correct way of doing this search and replace action?
--
tb