How to Find and Replace tildes and wildcard characters in Excel for Mac

Article translations Article translations
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.
Expand all | Collapse all

On This Page

SUMMARY

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 (~~).

MORE INFORMATION

Example 1: How to Find and Replace Numbers

To replace wildcard characters (*) in a numeric value in a worksheet cell, use the steps in the following example:
  1. Type 494** in cell A1.
  2. Select cell A1.
  3. On the Edit menu, click Replace.
  4. In the Find what box, type ~* (press TILDE, and then press ASTERISK).
  5. In the Replace with box, type 2.
  6. Click Replace.
Cell A1 now reads 49422.

NOTES:
  • When you click Replace All, Excel for Mac makes the change throughout the worksheet. When you click Replace, Excel for Mac changes only the currently active cell and leaves the Replace dialog box open.

  • When you type an asterisk without a tilde in the Find what box, Excel for Mac replaces all entries with a 2. Excel for Mac treats the asterisk as a wildcard character. Therefore, 494** becomes 2.

Example 2: How to Find and Replace a Tilde

To replace a tilde in an Excel for Mac worksheet cell, use the steps in the following example:
  1. Type Micros~ in cell A1.
  2. Select cell A1.
  3. On the Edit menu, click Replace.
  4. In the Find what box, type:
    ~~
  5. In the Replace with box, type:
    oft
  6. Click Replace All.
Cell A1 now reads Microsoft.

REFERENCES

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.

Properties

Article ID: 321819 - Last Review: February 1, 2007 - Revision: 3.1
APPLIES TO
  • Microsoft Excel X for Mac
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh
Keywords: 
kbinfo KB321819
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com