HPE Community
Operating System - Microsoft
1751854 Members
5479 Online
108782 Solutions
New Discussion юеВ

find & replace special characters in Excel

 
SOLVED
Go to solution
Richard Darling
Trusted Contributor

тАО02-06-2002 12:44 PM

тАО02-06-2002 12:44 PM

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
0 Kudos
Reply
2 REPLIES 2
Enes Dizdarevic
Honored Contributor

тАО02-06-2002 11:54 PM

тАО02-06-2002 11:54 PM

Solution

Re: find & replace special characters in Excel

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

Reply
Richard Darling
Trusted Contributor

тАО02-07-2002 05:44 AM

тАО02-07-2002 05:44 AM

Re: find & replace special characters in Excel

Thanks Enes,
That solved it.
RD
rdarling@southwickclothing.com
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.