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…

=TRIM(B2)

Select cells Select the menu choice Data Select the menu choice Text to Columns