I do a lot of spreadsheets where I type certainl chemical formulas over and over (CO2, H2O, CH4, N2O). When I finalize the report I am having to go into each instance and manually subscripting the number which takes forever. I am aware of a way to use autocorrect where I can type in something like CO/2 and get it to replace it with formatted text. That works, but it does me no good when someone else types the spreadsheet and does not have my autocorrect entries. I want to have a macro that will look for all instances of thes formulas within each cell and replace the numeral with a subscripted numeral. I found a macro online that will do this if the only text in the cell is the formula ("CO2" is the only text in the cell), but sometimes a cell will contain other things such as ("CO2 emission rate"). I have some basic knowlege of VBA but I don't know how to tackle this one. I assume I would need to have excel step through each string in each cell looking for these patterns, then somehow use the Font.Subscript commend to subscript it. Any ideas?