https://community.hpe.com/t5/operating-system-microsoft/find-amp-replace-special-characters-in-excel/m-p/2660153#M1731 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. <BR />Thanks...<BR />Richard Darling<BR /> Wed, 06 Feb 2002 20:44:25 GMT Richard Darling 2002-02-06T20:44:25Z https://community.hpe.com/t5/operating-system-microsoft/find-amp-replace-special-characters-in-excel/m-p/2660153#M1731 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. <BR />Thanks...<BR />Richard Darling<BR /> Wed, 06 Feb 2002 20:44:25 GMT https://community.hpe.com/t5/operating-system-microsoft/find-amp-replace-special-characters-in-excel/m-p/2660153#M1731 Richard Darling 2002-02-06T20:44:25Z https://community.hpe.com/t5/operating-system-microsoft/find-amp-replace-special-characters-in-excel/m-p/2660154#M1732 When you want to use special characters: ~, * and ? in you search/replace strings use ~~, ~*, ~?.<BR /><BR /> Thu, 07 Feb 2002 07:54:57 GMT https://community.hpe.com/t5/operating-system-microsoft/find-amp-replace-special-characters-in-excel/m-p/2660154#M1732 Enes Dizdarevic 2002-02-07T07:54:57Z https://community.hpe.com/t5/operating-system-microsoft/find-amp-replace-special-characters-in-excel/m-p/2660155#M1733 Thanks Enes,<BR />That solved it.<BR />RD Thu, 07 Feb 2002 13:44:23 GMT https://community.hpe.com/t5/operating-system-microsoft/find-amp-replace-special-characters-in-excel/m-p/2660155#M1733 Richard Darling 2002-02-07T13:44:23Z