RIGHT(B5,LEN(B5)-C5) (= FRONT RIGHT) To remove the first character from the selected string, the formula employs Excel’s RIGHT and LEN functions. This formula refers to cell C5, which records the number of characters to be removed. However, because this formula simply removes the first character from a string, this value will always be 1. Therefore, you can just type 1 into the formula.