Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Wildcard characters with time | Excel Discussion (Misc queries) | |||
Wildcard characters, IF functions | Excel Worksheet Functions | |||
wildcard characters | Excel Discussion (Misc queries) | |||
HELP: Wildcard Characters | Excel Discussion (Misc queries) | |||
WildCard Characters | Excel Worksheet Functions |