|I know that I know how to do this, but I fear that last night's excesses are coming back to bite me.|
Basically, I have a sheet containing 600 rows of data. I want a simple Yes/No to be displayed in Column B when the text string in Column A includes the word 'Trust'.
eg Cell A205 says 'Liverpool NHS Trust', or 'The Trust Company'. Column B will then say 'YES'.
Can someone help me please?
Any assistance much appreciated!