How to Prepend or Postpend Characters into an Excel Row/Column Cell


 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

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

 

 

Share