View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
F. Lawrence Kulchar F. Lawrence Kulchar is offline
external usenet poster
 
Posts: 124
Default WILDCARD CHARACTERS

I DO NOT UNDERSTAND ANY OF THE FOLLOWING...PLEASE ILLUSTRATE EXAMPLES, USING,
eg. THE =IF(......) FUNCTION THE USE OF:

?
*
and
~

Wildcard characters
The following wildcard characters can be used as comparison criteria
(criteria: Conditions you specify to limit which records are included in the
result set of a query or filter. For example, the following criterion selects
records for which the value for the Order Amount field is greater than
30,000: Order Amount 30000.) for filters, and when searching and replacing
content.

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?"


PLEASE EXPLAIN.

Thanks,

FLKulchar