Article ID: 321819 - View products that this article applies to.
This article was previously published under Q321819
For a Microsoft Excel for Windows version of this article, see 214138
Microsoft Excel for Mac uses the tilde (~) as a marker to indicate that the next character is a literal. When you click Find or Replace on the Edit menu to replace or search for a tilde (~), an asterisk (*), or a question mark (?), you must precede the character with a tilde (~).
NOTE: If you want to find or replace a tilde in your worksheet, you must type a double tilde (~~).
Example 1: How to Find and Replace NumbersTo replace wildcard characters (*) in a numeric value in a worksheet cell, use the steps in the following example:
Example 2: How to Find and Replace a TildeTo replace a tilde in an Excel for Mac worksheet cell, use the steps in the following example:
For more information about how to find and replace wildcard characters, click the Office Assistant, type wildcard characters you can use to find text or numbers, click Search, and then click a topic to view it.
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar.
Article ID: 321819 - Last Review: February 1, 2007 - Revision: 3.1
Contact us for more help
Connect with Answer Desk for expert help.