Next, you must select a column to the right of Column D, then press CTRL + R. The results should appear on your screen, as easy as you like. 2] Apply Same Formula to Multiple Cells in Excel using ...

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