|
| 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
July 23rd, 2004, 07:33 AM
|
|||
|
|||
IF with text
I'm trying to write an statement that will search a cell for part of a string containing "brick". ie the next four lines each contain "brick" and i need to return a result. brick Bricks some bricks and bricks in packs I've tried.... =IF(A1="*brick*,"yes","no") etc with no luck.... Anyone got any ideas????? 
|
|
#2
July 23rd, 2004, 08:04 AM
|
|||
|
|||
|
IF with text
Hi
one way: =IF(ISNUMBER(SEARCH("brick",A1)),"yes","no") or try =IF(COUNTIF(A1,"*brick*"),"yes","no") -- Regards Frank Kabel Frankfurt, Germany wayne wrote: I'm trying to write an statement that will search a cell for part of a string containing "brick". ie the next four lines each contain "brick" and i need to return a result. brick Bricks some bricks and bricks in packs I've tried.... =IF(A1="*brick*,"yes","no") etc with no luck.... Anyone got any ideas?????
|
|
#3
July 23rd, 2004, 08:05 AM
|
|||
|
|||
|
IF with text
Hi Wayne I guess you can use this formulae Under the assumption you are looking for brick in A1 then =IF(ISERROR(FIND("brick",A1)),"",Desired Result) This should fulfil your requirement. Regards "wayne" wrote: I'm trying to write an statement that will search a cell for part of a string containing "brick". ie the next four lines each contain "brick" and i need to return a result. brick Bricks some bricks and bricks in packs I've tried.... =IF(A1="*brick*,"yes","no") etc with no luck.... Anyone got any ideas?????
|
|
#4
July 23rd, 2004, 08:30 AM
|
|||
|
|||
|
IF with text
Raj,
He won't get the "Desired Result" without these " "! g Biff -----Original Message----- Hi Wayne I guess you can use this formulae Under the assumption you are looking for brick in A1 then =IF(ISERROR(FIND("brick",A1)),"",Desired Result) This should fulfil your requirement. Regards "wayne" wrote: I'm trying to write an statement that will search a cell for part of a string containing "brick". ie the next four lines each contain "brick" and i need to return a result. brick Bricks some bricks and bricks in packs I've tried.... =IF(A1="*brick*,"yes","no") etc with no luck.... Anyone got any ideas????? .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Any way of forcing Plain Text Format universally? | Astra | General Discussions | 0 | June 4th, 2004 09:34 AM |
| Too many hyperlinks? | [email protected] | Powerpoint | 7 | May 25th, 2004 02:19 AM |
| Vertical Text Orientation | Paul Anderson [MSFT] | Visio | 0 | May 11th, 2004 05:16 PM |
| Column separator crosses through wrapped text box | Bob S | Page Layout | 0 | April 25th, 2004 09:52 PM |
| Extracting text | Nemo | Worksheet Functions | 3 | April 6th, 2004 02:33 PM |
Linear Mode
