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 ...

Eg. We are creating the list in column C. If the first cell in the column for which we need to add the prefix is A3, and the prefix is TWC, the formula would be: ="TWC "&A3 ...