Excel Replace Asterix and Tilde

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 you click Replace All, Excel makes the … Continue reading Excel Replace Asterix and Tilde