http://www.extendoffice.com/documents/excel/670-excel-add-text-to-beginning-end-of-cell.html#formula
There are two formulas to add specified text to the beginning or end of all selected cells in Microsoft Excel.
Method 1: & formula
Enter the =”Class A: “&A1 in Cell E1, and copy this formula to other cells with dragging the bottom right corner of the Cell E1.