Hello all!

Does anyone know how I may be able to search a string and extract text from 
it using the MID and FIND function with multiple FINDS?  I have a spreadsheet 
for which I have a lengthy bit of text for which I have set up to currently 
extract ",IE".  I need to adapt the formula 
=MID(Dump!A1,FIND(",IE.",Dump!A1)-2,5) to also search for either ",MA" or a 
",MC".  These characters will always be unique and there will not be a 
combination of either in the text string.  The string will have either one of 
the three but not two or all of them.  I thought there may be an OR function 
I could use but am having no luck.

Thank you for your time any any help you may be able to provide.

First of all, I prefer to use SEARCH rather than FIND because FIND is
case-sensitive, although that might be important to you. Here's one
way of doing it:

=3DIF(ISNUMBER(SEARCH(",IE.",Dump!A1)),MID(Dump!A1,SEARCH(",IE.",Dump!
A1)-2,5),"")& IF(ISNUMBER(SEARCH(",MA",Dump!A1)),MID(Dump!A1,SEARCH
(",MA",Dump!A1)-2,5),"")& IF(ISNUMBER(SEARCH(",MC",Dump!A1)),MID(Dump!
A1,SEARCH(",MC",Dump!A1)-2,5),"")

All one formula - hopefully you can see how it could be extended to
include other conditions.

Hope this helps.

Pete

On Jan 13, 3:15=A0pm, Brenda <Bre...@discussions.microsoft.com> wrote:
> Hello all!
>
> Does anyone know how I may be able to search a string and extract text fr=
om
> it using the MID and FIND function with multiple FINDS? =A0I have a sprea=
dsheet
> for which I have a lengthy bit of text for which I have set up to current=
ly
> extract ",IE". =A0I need to adapt the formula
> =3DMID(Dump!A1,FIND(",IE.",Dump!A1)-2,5) to also search for either ",MA" =
or a
> ",MC". =A0These characters will always be unique and there will not be a
> combination of either in the text string. =A0The string will have either =
one of
> the three but not two or all of them. =A0I thought there may be an OR fun=
ction
> I could use but am having no luck.
>
> Thank you for your time any any help you may be able to provide.

Thanks Pete!  I appreciate your help.  This did the trick and I learned 
something!

"Pete_UK" wrote:

> First of all, I prefer to use SEARCH rather than FIND because FIND is
> case-sensitive, although that might be important to you. Here's one
> way of doing it:
> 
> =IF(ISNUMBER(SEARCH(",IE.",Dump!A1)),MID(Dump!A1,SEARCH(",IE.",Dump!
> A1)-2,5),"")& IF(ISNUMBER(SEARCH(",MA",Dump!A1)),MID(Dump!A1,SEARCH
> (",MA",Dump!A1)-2,5),"")& IF(ISNUMBER(SEARCH(",MC",Dump!A1)),MID(Dump!
> A1,SEARCH(",MC",Dump!A1)-2,5),"")
> 
> All one formula - hopefully you can see how it could be extended to
> include other conditions.
> 
> Hope this helps.
> 
> Pete
> 
> On Jan 13, 3:15 pm, Brenda <Bre...@discussions.microsoft.com> wrote:
> > Hello all!
> >
> > Does anyone know how I may be able to search a string and extract text from
> > it using the MID and FIND function with multiple FINDS?  I have a spreadsheet
> > for which I have a lengthy bit of text for which I have set up to currently
> > extract ",IE".  I need to adapt the formula
> > =MID(Dump!A1,FIND(",IE.",Dump!A1)-2,5) to also search for either ",MA" or a
> > ",MC".  These characters will always be unique and there will not be a
> > combination of either in the text string.  The string will have either one of
> > the three but not two or all of them.  I thought there may be an OR function
> > I could use but am having no luck.
> >
> > Thank you for your time any any help you may be able to provide.
> 
> .
> 

Glad to hear it, Brenda - thanks for feeding back.

Pete

On Jan 13, 6:15=A0pm, Brenda <Bre...@discussions.microsoft.com> wrote:
> Thanks Pete! =A0I appreciate your help. =A0This did the trick and I learn=
ed
> something!
>
>
>
> "Pete_UK" wrote:
> > First of all, I prefer to use SEARCH rather than FIND because FIND is
> > case-sensitive, although that might be important to you. Here's one
> > way of doing it:
>
> > =3DIF(ISNUMBER(SEARCH(",IE.",Dump!A1)),MID(Dump!A1,SEARCH(",IE.",Dump!
> > A1)-2,5),"")& IF(ISNUMBER(SEARCH(",MA",Dump!A1)),MID(Dump!A1,SEARCH
> > (",MA",Dump!A1)-2,5),"")& IF(ISNUMBER(SEARCH(",MC",Dump!A1)),MID(Dump!
> > A1,SEARCH(",MC",Dump!A1)-2,5),"")
>
> > All one formula - hopefully you can see how it could be extended to
> > include other conditions.
>
> > Hope this helps.
>
> > Pete
>
> > On Jan 13, 3:15 pm, Brenda <Bre...@discussions.microsoft.com> wrote:
> > > Hello all!
>
> > > Does anyone know how I may be able to search a string and extract tex=
t from
> > > it using the MID and FIND function with multiple FINDS? =A0I have a s=
preadsheet
> > > for which I have a lengthy bit of text for which I have set up to cur=
rently
> > > extract ",IE". =A0I need to adapt the formula
> > > =3DMID(Dump!A1,FIND(",IE.",Dump!A1)-2,5) to also search for either ",=
MA" or a
> > > ",MC". =A0These characters will always be unique and there will not b=
e a
> > > combination of either in the text string. =A0The string will have eit=
her one of
> > > the three but not two or all of them. =A0I thought there may be an OR=
 function
> > > I could use but am having no luck.
>
> > > Thank you for your time any any help you may be able to provide.
>
> > .- Hide quoted text -
>
> - Show quoted text -