The function should look something like this: "RIGHT (B2,4)." Remove text strings using Excel 2007's "Replace" command. Select all the cells in which you want to replace characters.

In Microsoft Excel, you are not just able to count characters in a single/multiple cell, but also specific characters in a cell or range of cells.