• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1899
  • Last Modified:

Find and replace a * in Excel 2010

I have an excel spreadsheet that I need to edit, specifically removing Asterisks that are in text paragraphs.  If I do a find and replace for a * I think it's thinking that means everything in any cell.  How do I actually tell it to just search for the actual symbol and delete just that?  

Thanks.
0
Longshot9
Asked:
Longshot9
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
To search for the wildcard characters asterisk and question mark, precede those characters with a tilde character (~). To search for a tilde character, use two tilde characters in sequence. To replace wildcard characters with other characters enter just that character preceded by a tilde in the "Find what" text entry field, and the characters with which to replace the wildchard character into the "Replace with" text entry field.

Kevin
0
 
jppintoCommented:
You need to add a ~ before the asterisk, like on the attached image.

jppinto
Capture.JPG
0
 
jerbear1337Commented:
in the "find what:"  type   ~*   that will replace all asterisks
0
 
Longshot9Author Commented:
Awesome, worked like a charm.  Thanks zorvek
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now