To concatenate means to join two or more things together. In excel, if you want to join two text strings together, one way to do that is with an ampersand, as shown below. There is also an excel function called =CONCATENATE. However, if you need to join more than a few items together, this quickly becomes tedious. Please write a function to concatenate all the members in a single range. The function should take an optional second argument which will separate the items in the list. Example:
Add a comment section to this VBA function and save it to your custom function add in.