I have tried to put some example data (using pre) here. As the sentences are long (though I tried to cut-short them) and the preview did not really showed me all of it. There could be some mismatch (but separation by Tab or 5 spaces is there to know data from the next column). My apologies again.
Now in Coumn G, H, I, J and a few more I want add certain terms like Diesel, exhaust, emission, SCR, ammonia, urea or a phrase like "NOx reduc" and the macro can look into the text in Columns A-F and just highlight the input terms in the text present.
Please let me know if you need more clarity.
# Year Company Ti Short Details
1 2003 XYZ Reducing agent concentration (NH3) A method for determining the reducing agent concentration (NH 3 ) in the exhaust-gas flow of an internal combustion engine, using a zeolitic NH3 gas sensor that supplies a base measuring value. A method for determining the reducing agent concentration (NH3) in the exhaust-gas flow of an internal combustion engine with an NH3 gas sensor that supplies a base measuring value, comprising initially correcting the base measuring value by an offset value and a correction value that depends on the H2O concentration in the exhaust gas to obtain an intermediate value; and subsequently changing the intermediate value with the aid of the NOx concentration in the exhaust gas to provide a corrected NH3 measuring value.
2 2010 ABC EXHAUST GAS CATALYST An exhaust gas purifying catalyst that meets the requirement concerning Hg oxidation activity and SO 2 oxidation activity; i.e., an exhaust gas purifying catalyst which specifically reduces percent SO2 oxidation, while maintaining percent Hg oxidation at a high level. "A catalyst for purifying an exhaust gas containing metallic mercury (Hg) comprising a composition containing oxides of (i) titanium (Ti), (ii) molybdenum (Mo) and/or tungsten (W), (iii) vanadium (V), and (iv) phosphorus (P), wherein the catalyst contains Ti, Mo and/or W, and V in atomic proportions of 85 to 97.5:2 to 10:0.5 to 10, and has an atomic ratio of P/(sum of V and Mo and/or W) of 0.5 to 1.5.
3 2007 ZXS Reducing agent control A process for reducing agent control in an exhaust gas aftertreatment system of a combustion engine with an exhaust gas pipe in which in the direction of flow of the exhaust gas there is an SCR catalyzer. A method of reducing agent control in an exhaust gas aftertreatment system of a combustion engine with an exhaust gas pipe in which in the direction of flow of the exhaust gas there is an SCR catalyzer, whereby a reducing agent generating system has an NOx and CO/H2 generating unit, an oxidation catalyzer, and a combined NOx storage/ammonia generating unit in the standard gas path of the reducing agent generating system.