| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract from string
Niek,
works great thank you Mark Niek Otten wrote: Hi Mark, In G3: =IF(I3="",IF(ISERROR(FIND("ad",F3)),"","ad"),"") In H3: =IF(I3="",IF(ISERROR(FIND("con",F3)),"","con"),"") In I3: =IF(OR(ISERROR(FIND("ad",F3)),ISERROR(FIND("con",F 3))),"","ad, con") -- Kind regards, Niek Otten Microsoft MVP - Excel "mark" wrote in message oups.com... | Hi All, | I want to be able to extract some text from various strings and place | it in the cell(s) to the right. | I'm looking for combinations of Ad or Con or both Ad and Con | similar to the following examples say in F3 | "Wants Ad,Die" or "Wants Con,Die" | I want to be able to extract out the Ad or Con and place into G3 | for Ad or H3 for Con | | "Wants Ad,Con,Die" | I want to be able to extract out Ad,Con and place into I3 | | With this I'll be able to see who wants Ad only, Con only and Ad and | Con combined. | Some of the strings do not have Ad or Con at all. | | Thank you | Mark | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract text from String | Excel Worksheet Functions | |||
| List File Properties - Author | Excel Worksheet Functions | |||
| Extract Numbers from Alpha-Numeric String | Excel Worksheet Functions | |||
| Extract sub string | Excel Worksheet Functions | |||
| How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions | |||
Threaded Mode
