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

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

My favorite is Concatenate. Simply mastering this function can make so many laborious tasks quicker, which ultimately means there is more time for the juicier optimization opportunities. First quick ...