LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wildcard characters with time Deborah S Excel Discussion (Misc queries) 4 May 28th 09 02:35 PM
Wildcard characters, IF functions PMBO Excel Worksheet Functions 1 November 15th 06 04:54 PM
wildcard characters Hasty Excel Discussion (Misc queries) 2 July 21st 06 10:40 AM
HELP: Wildcard Characters bbddvv Excel Discussion (Misc queries) 0 June 28th 06 02:38 PM
WildCard Characters Ralph Heidecke Excel Worksheet Functions 1 June 1st 06 07:43 PM


All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"