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.

Within the double quotes, you can add any text, numbers, symbols, or spaces. Excel will ensure they are appended to the existing cell. Now, if you prefer to use Functions instead of formulas, then ...

Excel and data analysis are part of day-to-day internet marketing. Google Analytics, Google Search Console, Ahrefs, Moz the list of data providers goes on ...