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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

making a cell a search/find field 5
How to give find function ( same as of ctrl F) in formula bar 3
ctrl+F command 1
How do you find and replace a Wildcard character in Excel? 8
Word macro that can call cells out of Excel for a find and replace 0
Excel does not accept text format! 0
macro on different reports CTRL+F in formula 2
how to remove #REF and #N/A 4

Top