Replace '*'

[Edgar]

Hi

How do you replace the * character in Excel. Whenever I
try and replace '*' with ' ' it deletes all text. Guess
its to do with the wildcard.

TIA

 

[Harald Staff]

Hi

Place a tilde in front of a special character to say "i mean this exact
character":

~*