Description
The Concatenate function in Excel is powerful in that it can create unique identifiers to help you sort and better understand your dataset. One issue with the Concatenate function is when you want to join many columns together in Excel. Setting up a Concatenate formula across 10 or more cells becomes an opportunity to pick your pain either doing a lot of typing or clicking. You can use the TextJoin function in Excel which is designed to handle concatenation across a range of cells. If you want to avoid typing a formula in Excel, then checkout Leverage & Lean’s Excel Quick Concatenate across Multiple Cells macro!