Removing non text characters from spreadsheet

[Katie59]

I am trying to remove a string of asterisks *** from a series of worksheets.
How do I indicate in the find box that I am looking for asterisks. I have
searched Help, and cannot find.

 

[Gary''s Student]

Tilda can help yor.

Lokk for ~*

 

[via135]

hi!

CTRL+H

Find what: ~*
Replace with -leave blank-

click Replace All.

-via135

 

[David Biddulph]

I am trying to remove a string of asterisks *** from a series of
worksheets.
How do I indicate in the find box that I am looking for asterisks. I have
searched Help, and cannot find.

Precede the *** in the find box by a tilde ~

 

[Katie59]

Thank you both, but in my case, I had already tried that and it does not
work. Maybe the other text in the cell makes a difference. In almost all
cases there are 3 asterisks and then text up tight. EX ***TSH(Thyroid
Stimulatin Hormone).
Oops! I was putting ~*** in the box, I just tried ~* and it worked. Thank
you!