How to Find & Replace Text Parts in MS Excel. Manually finding and replacing parts of text can be exceedingly tedious for lengthy Excel spreadsheets. ... How to Remove Characters in Excel 2007.

For the New_text, we will enter “P” because this is the text we will replace the three characters with. It should look like this; =REPLACE(A3,7,3, “P”). Press Enter, you will see results.