Software runs successfully on Windows 98, 2000, XP, 2003, Vista &
Windows 7
| |
Microsoft Excel provides the following special 'wildcard' characters.
| Use |
To find |
| ? (question mark) |
Any single character
For example, sm?th finds "smith" and "smyth" |
| * (asterisk) |
Any number of characters
For example, *east finds "Northeast" and "Southeast" |
| ~ (tilde) followed by ?, *, or ~ |
A question mark, asterisk, or tilde
For example, fy91~? finds "fy91?" |
Microsoft Excel 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 (~~).
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, then save and close the
document. |
| 2. |
Select cell A1.
|
| 3. |
In ExcelPipe's
Find what
box, type ~*
(press TILDE, and then press
ASTERISK). |
| 4. |
In the
Replace with
box, type 2.
|
| 5. |
Click Replace.
|
Cell A1 will now read
49422.
NOTE:
| • |
When you type an
asterisk without a tilde in the
Find what
box, ExcelPipe replaces all entries
with a 2. Excel 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 worksheet
cell, use the steps in the following
example:
| 1. |
Type
Micros~1.xls
in cell A1.
|
| 2. |
Select cell A1,
then save and close the document. |
| 3. |
In ExcelPipe's
Find what
box, type:
~~
|
| 4. |
In the
Replace with
box, type:
oft
|
| 5. |
Click Replace
All. |
Cell A1 now reads Microsoft1.xls.
|
|
We
are here to provide technical support to our customers.