icestationzbra,

The formulas seem to work perfect. Thank you!

So please correct me if I'm wrong but to use this I'd create a spread sheet with a sheet named Large Keyword List another names Main Keyword List.
Then I'd take the formula from column B and copy it down. Then I'd take the formula on the second sheet in column B and copy it down and it should work?
I tried to copy the formula down to all cells by clicking on the lower right hand corner of the cell. This usually works but did not for either formula. Is there another way to quickly copy the formula down as my spreadsheets sometimes have over 100K keywords and it would take forever to drag it down.
Also, when I copied this formula to my existing spreadsheet it worked but didn't highlight the cells, not sure if I'm doing something wrong.

Thanks again for all your help and patience!