Operating System - Microsoft
cancel
Showing results for 
Search instead for 
Did you mean: 

find & replace special characters in Excel

SOLVED
Go to solution
Richard Darling
Trusted Contributor

find & replace special characters in Excel

I need to find and replace all asteriks in a spreadsheet with a blank. Since an asterik is a special character I need to take away the "specialness", or meta/magic value, as it is referred to in UNIX.
Thanks...
Richard Darling
rdarling@southwickclothing.com
2 REPLIES
Enes Dizdarevic
Honored Contributor
Solution

Re: find & replace special characters in Excel

When you want to use special characters: ~, * and ? in you search/replace strings use ~~, ~*, ~?.

Richard Darling
Trusted Contributor

Re: find & replace special characters in Excel

Thanks Enes,
That solved it.
RD
rdarling@southwickclothing.com