I am using the following piece of code in the attached workbook to identify if the word 'Subjects' appears in column B of the relevant row and, if so, place the word 'Subjects' in column D.
=IF(ISNUMBER(FIND("/subjects/",B2)),"Subjects","")
This is working fine, however I would like to extend this. Instead of leaving column D blank if 'Subjects' does not appear, I would like it to copy the text in column B into column D. (See attachment for an example).
Can someone help me out with a way to do this?
Thanks
Glayva
Bookmarks