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.
- If you want to add specified text in each cell, just replace theClass 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.