The Find() function returns a number for the location of the character(s)
we're looking for.
In this case, it's the comma.
If that character is not found, Find() returns an error (#VALUE!).

Isnumber() evaluates the return of the Find() function ...
TRUE if it's a number (character found),
FALSE if it's an error (character *not* found).

SO, the return of Isnumber() designates which argument of that final IF()
formula will fire ...
the value-if-true, the text ", activated" ...
or, the value-if-false, a blank ( "" ).

Finally, try out this shorter version of the parsing formula.
It should do the same job as the original:

=MID(A1,SEARCH(") for",A1)+6,(FIND("(h)",A1)+2)-(SEARCH(") for",A1)+5))
&IF(ISNUMBER(FIND(",",A1)),", activated","")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Hankjam" ........ wrote in message
...
On Sat, 27 Sep 2008 17:22:37 -0700, "Ragdyer"
wrote:

I see only one comma when "activated" is present.

Does this work for you:


=TRIM(MID(SUBSTITUTE(A1,"for","^^",2),FIND("^^",S UBSTITUTE(A1,"for","^^",2)
)
+3,

FIND("(h)",A1)-FIND("^^",SUBSTITUTE(A1,"for","^^",2)))&IF(ISNUMBE R(FIND(","
,
A1))," activated",""))
Hi

It surely did.

I've figured out how most of this works.

Could you explain the use of ISNUMBER?

Many thanks again

Aj