Choose.
 

I am currently using a similar statement in a DB,
how may I adapt it to an Excel cell please?
(striking trouble with the divisor into the text string)

=CHOOSE(FIND(VENUE,"W ANSWVICS AN TCANTAS",0)/3,1,2,3,4,5,6,7)

Thank you.

Hi Rodney,

Try changing the zero to one.

Gary

Hi Gary,
Yep, that fixed it nicely.
appreciated.



| Hi Rodney,
| Try changing the zero to one.
| Gary