We help IT Professionals succeed at work.

Which cells say "Added Lesson" in them

I have a column of cells that has data in it (in the form of sentences). In column B, I would like it to say "Added Lesson" if there is text in column A saying "Added Lesson". If there is not text that says "Added Lesson" it should say "Other".

THanks!
Comment
Watch Question

Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Assuming your data starts from A1, add below formula in B1 and drag down:
=IF(ISNUMBER(SEARCH("Added Lesson",A1)), "Added Lesson", "Other")

Open in new window

Author

Commented:
That didn't seam to work.

Just to be clear.. they are whole sentences. Somewhere in the sentence it says "Added Lesson".
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Refresh this page again, I have changed the formula

Author

Commented:
Thanks!