| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search for text "beginning with" "containing" wildcards
I have numerous occasions where functions (like countif) need to report on
cells containing text strings or starts with text strings. In various database utilities there are wildcards which provide this functionality, but what about in Excel, do any wildcards work ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
search for text "beginning with" "containing" wildcards
In some functions, they do:
=countif(a1:a10,"text*") =countif(a1:a10,"*text") =countif(a1:a10,"*text*") And you can use "*" & x99 & "*" as the second argument. If you want to look for an asterisk character, use ~* in the string. If you want to look for a question mark, use ~? in the string. If you want to look for a tilde (~), use ~~ in the string. David H wrote: I have numerous occasions where functions (like countif) need to report on cells containing text strings or starts with text strings. In various database utilities there are wildcards which provide this functionality, but what about in Excel, do any wildcards work ? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF(ISNUMBER(SEARCH("ELB",B2)),"Pipe") add more like "ELB" "FLG" | Excel Worksheet Functions | |||
| =IF(ISERROR(SEARCH("insurance",A125,1)),"","*") | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
