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

Adding line breaks can help make the labels for your data more readable and can even be used to create a dual-label cell. Double-click the cell to which you want to add the line or paragraph break.

Instead, you need to use the CONCATENATE formula to combine that data. In the Excel worksheet where you want to combine two columns of data, first insert a new column near the data you want to ...