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

This article was previously published under Q321819
This article has been archived. It is offered "as is" and will no longer be updated.
For a Microsoft Excel for Windows version of this article, see 214138.
SUMMARY
Microsoft Excel for Mac uses the tilde (~) as a marker to indicate that the nextcharacter 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.
MacXLX Mac XLX XL2001 XL98
Properties

Article ID: 321819 - Last Review: 12/07/2015 10:50:23 - Revision: 3.1

Microsoft Excel X for Mac, Microsoft Excel 2001 for Mac, Microsoft Excel 98 for Macintosh

  • kbnosurvey kbarchive kbinfo KB321819
Feedback