Identify cells containing the word "Sales"

I have a file with 1500 rows. Each row contains names the following: A1= Co Name. B1 = Co address, C1 = State & Zip D1 = John Smith, E1 = CEO, F1 = Joe Brown, G1 = Vice President, etc. There are ten names and positions in each row. What I need to do is pull out of each row the name and position of any executive who has the word "Sales" in his/her title. Titles could be Sales Mgr, Sales Exec, Mgr Sales, V.P. Sales, etc. There could also be more than one title in a row containing the word Sales.

Hi ElsiePOA,

Welcome to the forum.

Try using Advanced Filter option of Excel with wildcharacters... thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>