We explain the concatenate formula in Excel, including how to combine cells in Excel with it and add spaces between words. By Ryan Maskell April 4, 2024 1:18 pm CEST ...

Step 1: To concatenate cells in Excel without using its formula, enter, for example, =A2 & B2. This will save you from entering the formula itself, which, in this case, would be =CONCATENATE(A2,B2) .

Move your cursor to column J and enter the following text formula: =CONCATENATE(H3, “ “, I 3). Note there’s a space between the quotation marks, so Excel places a space between the two words ...

Use this function to display the “text” of a formula in a given cell. For example, the actual formula in cell E2 is =SUM(C2*D2); but all you see is the answer, which is $164.25.