Why not allow matching wildcards (? and *) in the REPLACE string as well as
in the FIND string? Using the Excel FIND AND REPLACE feature is handicapped
by the inability to copy the wildcard strings from the FIND operation and
restore it as part of the REPLACE operation. Often users want to use the
wildcard characters as a template to find strings in order to replace the
common component, but do NOT want to replace the wildcard component.

For example, we want to FIND Building 1A1, Building 2B2, and Building 3C3
and REPLACE it with Building 1-A1, Building 2-B2, and Building 3-C3. This
could easily be performed if we could search for €œBuilding ???€� and replace
it with €œBuilding ?-??€�, where the wildcards (?-??) in the replace string are
replaced by the wildcard characters found in the search string.
Unfortunately, using this example in the current version of Excel 2007, will
simply replace all the numbers with question marks instead of preserving the
wildcard characters in the find string.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc