Which cells say "Added Lesson" in them

cansevin
cansevin used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial