Copy formula in the range. In the example above A1 is the cell containing your original text. The next value we need to add is the flight number which is already there in the cell A2.
Just use the operator to concatenate the text and the formula.
Below are the steps to add a text before a text string in Excel. Heres how to create an addition formula. The first way is using the keyboard and the arrow keys the second way using the keyboard and mouse and a third way to use the keyboard by typing directly the formula and the address of cell involved. Add specified text to the beginning end of all cells with formulas.