Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

You can use this same formula to remove other characters from a string of values in Excel. You can also use the Right function, where you tell Excel to delete the numbers on the left and keep the ...