Example 1: How to find and to replace numbers To replace wildcard characters (*) in a numeric value in a worksheet cell, follow these steps: Type 494** in cell A1. Select cell A1. On the Edit menu, click Replace . Note In Microsoft Office Excel 2007, click Find & Select in the Editing group on the Home tab, and then click Replace . In the Find what box, type ~*. To do this, press TILDE, and then press ASTERISK. In the Replace with box, type 2. Click Replace . Cell A1 now reads 49422. Notes When