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.