Longshot9
asked on
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.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
in the "find what:" type ~* that will replace all asterisks
ASKER
Awesome, worked like a charm. Thanks zorvek
jppinto
Capture.JPG