** Add specified text to the beginning / end of all cells with formulas**

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.

**Method 2: Concatenate formula**

Enter the *=Concatenate (“Class A: “, A1)* in Cell E1, and copy this formula to other cells with with dragging the bottom right corner of the Cell E1.

**Notes**

- If you want to add specified text in each cell, just replace the
*Class A:*with your text in both formulas. - The formulas of
*=A1 & “Class A: ”*and*=Concatenate (A1, “Class A: “)*will add*Class A:*at the end of Cell A1. - Both formulas will not modify the contents in selection directly.