Press the Enter key after and be sure to change B2 and the word TheWindowsClub with your own text. When it comes down to using a Function instead, then we choose to use CONCAT all over again, but ...

Look to the Ribbon and find the Fill Color button. Choose your color and right away the cell will change. You can do the same with fonts by selecting the Font Color icon.

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.