can i have a formula that looks for one thing but with exceptions?
i.e. =IF(LEN(A5)3,1,"") but if A5 contains CMT, DIVS or FUND
many thanks