Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.

Instead, select the cell containing the formula, and double-click the fill handle rather than dragging it. In an instant, Excel duplicates the formula down the column until it reaches a blank row.