Thanks for your msg,
I'd like to scan B(B1:B5056) column for a certain word (e.g. "Project Management") and put a code (e.g. "PM") on the cell next to it each time it finds it. In this case, "Project Management" might be by itself or in the middle of a sentence.Also "Project Management" keyword can exist more than one place in the B column.
Can you help me pls?
Bookmarks