Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract from string
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract from string
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 | |
#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 | |
Reply |
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 |