Simple Excel Function to Combine Values in ALL Versions of Excel - UDF

Excel File:
Excel Forum:

Excel function that combines values from multiple cells or inputs using a delimiter - works for every version of Excel!

This function allows you to select ranges, select individual cells, input text, and input numbers and combine all of that data using a delimiter between each piece of data.

This tutorial will also cover the TEXTJOIN() function, which is new for Microsoft Excel 365 and later versions, but the beauty of the UDF (User Defined Function) in this tutorial is that it works for all versions of Excel!

So here, I show you the new way to combine values and then I show you how to do the same thing with older versions of Excel using a UDF VBA Macro that I made for you :)

I hope you enjoy the tutorial! Let me know your thoughts!

TeachExcel.com

combine text in excel,excel data combine,excel udf,text editing in excel,excel put text together,combine values in excel,concatenate in excel,textjoin excel,data manipulation functions in excel,ms office,microsoft excel,teachexcel.com,teachexcel,data analysis,office management,