Ron,
tx for ur reply. it does work...however, i oversimplified the example in
my op.
i believe using FIND is better for me as s'times, the word "firm" for
example will be in the middle and not right, as in ABCfirmpartnership.
i do recognize the value or what u propose tho; it is helpful.
if there r other suggestions--as there is often more than 1 way to skin
a cat in XL, i'd be glad to take a look.
tx.