Let’s take a look at how to use concatenate in Excel. Using the concatenate function for two columns in Excel. Step 1: Select the column and cell in which you’ll be combining data from other ...

I have a simple sub procedure in Excel (XP) that returns the total number of characters (Len()) in the selected cell block. Took me a long time to finally figure it out. Now I want to convert it ...

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