How can I find an asterik "*" in a spreadsheet using ctrl+F?

  • Thread starter pulling my hair out
  • Start date
P

pulling my hair out

I have a column of data that includes "*" asteriks and I want to eliminate
them. When I try to use ctrl+f to find and replace them with "blank" it
appears it reads the "*" as a wildcard and eliminate the entire cell. How do
I look specificaly for the "*"? Thanks for any help!!!!!
 
A

Anthony D

Hi,

An asterisk can be specified as a search term by preceding it with a tilde,
e.g.
~*

Hth
Anthony
 
Top