|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
08-06-2007, 12:34 PM
|
|||
|
|||
|
Using IF with wildcards
How do you do this?
in A1 John Andersson or Peter Johnsson or Peter johnsson If i want to find if there is a occurence of "john" inside these strings how do I do that?? IF(A1=contains("john"),"true","false") should return the value "true" for both above. is this possible?? Is there some kind of "contains" functionality?? /J 
|
|
#2
08-06-2007, 04:30 PM
|
||||
|
||||
|
Try
=ISNUMBER(SEARCH("john",A1))
|
|
#3
08-06-2007, 05:54 PM
|
||||
|
||||
|
If you are looking for "john" and not "John", then you could use
=ISNUMBER(FIND("john",A1)) The FIND function is case sensitive.
__________________
oldchippy -------------   Click here >>> Top Excel links for beginners to Experts Forum Rules >>>Please don't forget to read these
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
