How to replace the multiply (*) character

[excelstart]

Hi,

I am trying to replace *string with /string in a spreadsheet. Because * means all, using it in the replace box substitutes the whole content of the cells containing *string with /string.

I have also tried "*string" but it hasn't worked. Does anyone know how to do this, or maybe how to deactivate regular expressions in the replace box?

SC

 

[Aladin Akyurek]

Use

~*

instead of just

*

which would mean the wildcard char.