Matching keywords in column and coping to new column

[ktc]

I need to lookup key word in a column and put it in a new column. In other words, I need to find "jobs" in a column of comments.

The column has 6000 rows and each row has a statement...Such as jobs, unemployment, housing. This column is column B2-B6000. I need the word "jobs" to appear each time it is mentioned in this column in a new column C.

 

[The Zealot]

Have you tried the VLookUp Refresher?

 

[ktc]

Thank you...this is working.

 

[The Zealot]

That's great.

Any chance you could help me with my question please? I'm really stuck.

 

[ktc]

I will try...novice on excel.