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