Tim wrote:
Thanks everyone but i tried each soln and the words stay in the
column?

Hi Tim
you have to apply the data -validation prior to entering data into the
cells. Applied after entering does not work. Excel will only re-check
after re-entering data in this cell

Frank