| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
function with 'contain'
Hi Guys,
If e.g. in cell A1 I have following text 'Adam has 7 apples' is there any formual that would return in e.g. cell A2 '1' or 'true' or whatever if A1 has contains word 'Adam'. So in other words I'm looking for sth like this: = if A1 contains 'Adam' then in A2 return 1; if not then return 0. lucas |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function with 'contain'
=IF(ISERROR(FIND("Adam",A1)),0,1)
"lucas" wrote: Hi Guys, If e.g. in cell A1 I have following text 'Adam has 7 apples' is there any formual that would return in e.g. cell A2 '1' or 'true' or whatever if A1 has contains word 'Adam'. So in other words I'm looking for sth like this: = if A1 contains 'Adam' then in A2 return 1; if not then return 0. lucas |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function with 'contain'
=ISNUMBER(FIND("Adam"),A1)
will return TRUE or FALSE =--ISNUMBER(FIND("Adam"),A1) will return 1 or 0 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "lucas" wrote in message ... Hi Guys, If e.g. in cell A1 I have following text 'Adam has 7 apples' is there any formual that would return in e.g. cell A2 '1' or 'true' or whatever if A1 has contains word 'Adam'. So in other words I'm looking for sth like this: = if A1 contains 'Adam' then in A2 return 1; if not then return 0. lucas |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function with 'contain'
BTW, use
=--ISNUMBER(SEARCH("Adam",A1)) if you don't need case-sensitive -- HTH Bob Phillips (remove nothere from email address if mailing direct) "lucas" wrote in message ... Hi Guys, If e.g. in cell A1 I have following text 'Adam has 7 apples' is there any formual that would return in e.g. cell A2 '1' or 'true' or whatever if A1 has contains word 'Adam'. So in other words I'm looking for sth like this: = if A1 contains 'Adam' then in A2 return 1; if not then return 0. lucas |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function with 'contain'
thx. it helps!
"bpeltzer" wrote: =IF(ISERROR(FIND("Adam",A1)),0,1) "lucas" wrote: Hi Guys, If e.g. in cell A1 I have following text 'Adam has 7 apples' is there any formual that would return in e.g. cell A2 '1' or 'true' or whatever if A1 has contains word 'Adam'. So in other words I'm looking for sth like this: = if A1 contains 'Adam' then in A2 return 1; if not then return 0. lucas |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
function with 'contain'
thx Bob!
"Bob Phillips" wrote: BTW, use =--ISNUMBER(SEARCH("Adam",A1)) if you don't need case-sensitive -- HTH Bob Phillips (remove nothere from email address if mailing direct) "lucas" wrote in message ... Hi Guys, If e.g. in cell A1 I have following text 'Adam has 7 apples' is there any formual that would return in e.g. cell A2 '1' or 'true' or whatever if A1 has contains word 'Adam'. So in other words I'm looking for sth like this: = if A1 contains 'Adam' then in A2 return 1; if not then return 0. lucas |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Linear Mode
