Home |
Search |
Today's Posts |
#1
|
|||
|
|||
wildcards in formulas
How do I get a formula to include a wildcard?
For example, the remarks on the MATCH function say: If match_type is 0 and lookup_value is text, lookup_value can contain the wildcard characters asterisk (*) and question mark (?). An asterisk matches any sequence of characters; a question mark matches any single character. So I created a spreadsheet, and put the word "bananas" in cell b2. I then find that =MATCH("bananas",b1:b5,0) gives me 2 But =MATCH("ba*s",b1:b5,0) gives me #N/A, and taking the asterisk out of the quotes (=MATCH("ba" & * & "s",b1:b5,0), for example), gets me a formula error. So what's the proper syntax for getting that asterisk in there? |
#2
|
|||
|
|||
wildcards in formulas
That is the proper syntax, and works perfectly for me. You don't have a
trailing space by any chance? -- HTH RP (remove nothere from the email address if mailing direct) "GoBobbyGo" wrote in message ... How do I get a formula to include a wildcard? For example, the remarks on the MATCH function say: If match_type is 0 and lookup_value is text, lookup_value can contain the wildcard characters asterisk (*) and question mark (?). An asterisk matches any sequence of characters; a question mark matches any single character. So I created a spreadsheet, and put the word "bananas" in cell b2. I then find that =MATCH("bananas",b1:b5,0) gives me 2 But =MATCH("ba*s",b1:b5,0) gives me #N/A, and taking the asterisk out of the quotes (=MATCH("ba" & * & "s",b1:b5,0), for example), gets me a formula error. So what's the proper syntax for getting that asterisk in there? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wildcards in Formulas | Excel Discussion (Misc queries) | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Wildcards in formulas? | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |