Another way to write that:

=IF(OR(MID(F3,14,2)={"IP","IV"}),MID(F3,14,2),"not present")

Biff

"Pete_UK" wrote in message
ups.com...
Your data seems to be in F3, so try this:

=IF(OR(MID(F3,14,2)="IP",MID(F3,14,2)="IV"),MID(F3 ,14,2),"not present")

You can change the "not present" message to something more to your
liking, then copy the formula down if you have similar strings to test
below F3.

Hope this helps.

Pete

Batman wrote:

Hi Dave,

Didn't work for me... how about this way..this returns ip..

=IF(ISNUMBER(SEARCH("IP",F3)),"IP","")

I just can't figure out how to enter multiple values to get mulitple
returns.

Ryan

"Dave F" wrote:

=IF(LEFT(A1,14)="i",CONCATENATE(LEFT(A1,14),LEFT(A 1,15),"")

Dave
--
Brevity is the soul of wit.


"Batman" wrote:

Hi someone,

I'm trying to find and return specific text (the 14th and 15th
character)
from a cell, but only if its one of 6 different values (ex. "ip" or
"iv")

can someone provide a formula that could return only these 2 values,
and i
should be ok to replicate it from there??

Thanks,