|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 20th, 2010, 08:43 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wildacrds
Hi,
XL2003. Is it possible to use wildcards in simple logic statements? If A1 contains "qwerty" and B1 contains "qw" In C1 I've tried: =A1=B1* - xl complained =A1=B1&* -xl complained =A1=B1&"*" - returned FALSE Regards - Dave. 
|
|
#2
March 20th, 2010, 09:27 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
wildacrds
No. You need to use functions like Find or Search, as in:
=isnumber(search(b1,a1)) Regards, Fred "Dave" wrote in message ... Hi, XL2003. Is it possible to use wildcards in simple logic statements? If A1 contains "qwerty" and B1 contains "qw" In C1 I've tried: =A1=B1* - xl complained =A1=B1&* -xl complained =A1=B1&"*" - returned FALSE Regards - Dave.
|
|
#3
March 20th, 2010, 09:49 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
wildacrds
=LEFT(A1,2)=B1
-- Gary''s Student - gsnu201001 "Dave" wrote: Hi, XL2003. Is it possible to use wildcards in simple logic statements? If A1 contains "qwerty" and B1 contains "qw" In C1 I've tried: =A1=B1* - xl complained =A1=B1&* -xl complained =A1=B1&"*" - returned FALSE Regards - Dave.
|
|
#4
March 20th, 2010, 10:21 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
wildacrds
"No" is so final!
"Fred Smith" wrote: No. You need to use functions like Find or Search, as in: =isnumber(search(b1,a1)) Regards, Fred "Dave" wrote in message ... Hi, XL2003. Is it possible to use wildcards in simple logic statements? If A1 contains "qwerty" and B1 contains "qw" In C1 I've tried: =A1=B1* - xl complained =A1=B1&* -xl complained =A1=B1&"*" - returned FALSE Regards - Dave. .
|
|
#5
March 20th, 2010, 03:48 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
wildacrds
What are you trying to do? Are you trying to determine if a1 and b1
are equal? Is this user input? Glen On Mar 20, 1:43*am, Dave wrote: Hi, XL2003. Is it possible to use wildcards in simple logic statements? If A1 contains "qwerty" and B1 contains "qw" In C1 I've tried: =A1=B1* * *- xl complained =A1=B1&* * * *-xl complained =A1=B1&"*" * *- returned FALSE Regards - Dave.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
