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

Open your spreadsheet in Microsoft Excel. Locate the text you wish to concatenate. As an example, you might have text in cells A1 and A2. Type "=CONCATENATE (A1,A2)" in an empty cell to ...

Divide the text/numbers in a set of cells that are either pure text or pure numbers and format them accordingly. Play with several widths.<BR><BR> my 2 cents,<BR><BR> Caos ...

If you’re using Excel 2019 through Microsoft 365, there’s a function that can do the same thing, only quicker and with no helper column. How to combine values into a single cell using TEXTJOIN ...