Actually I found my problem but dont really know how to correct it. I
was looking for "ENT" and it displays this when "statement" is in the
cell even though i used "FIND" and "ENT" by itself is before statement
in the cell. is there a way i can correct this so it searchs from
left to right and stops once it finds it or something else i need to
do? Also, when it doesnt find a match it displays "NA" is there a way
i can keep it blank if it doesnt find anything?