Hello, I've tried several examples of formula's to try to get this to work but am failing to find a solution, although I'm sure it is relatively simple.

I have a column that in some cells contains a single text character, if text is found anywhere in the column then I want to return "in use".

hope you can help

thanks