Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to find and replace tildes and wildcard characters in Excel
Article ID: 214138 - View products that this article applies to.
This article was previously published under Q214138
For a Microsoft Excel for Macintosh version of this article, see 321819
Microsoft Excel uses the tilde (~) as a marker to indicate that the next character is a literal. When you use the Find and Replace dialog box to find or replace a character such as a tilde (~), an asterisk (*), or a question mark (?), you must add a tilde (~) before the character in the Find what box.
Note If you want to find or replace a tilde in a worksheet, you must type a double tilde (~~) in the Find what box.
Example 1: How to find and to replace numbersTo replace wildcard characters (*) in a numeric value in a worksheet cell, follow these steps:
Example 2: How to find and to replace a tildeTo replace a tilde in an Excel worksheet cell, follow these steps:
Article ID: 214138 - Last Review: January 23, 2007 - Revision: 4.2