Concatenation Archives - Struggling To Excel

Concatenate Unique Cells, with Text Formatting

By Ejaz February 18, 2014User Defined Function7 Comments

A fellow struggler requested me to help him with a slightly beefed up Range Concatenate function. He needed to combine a bunch of numbers in a range; there were multiple entries of the same number, and he wanted a unique list; finally he needed to format the numbers.

Concatenate a Range of Strings in Excel

By Ejaz November 14, 2013User Defined Function

Most of us have used the Concatenate() function in Excel. It is a neat function that saves you the trouble of keying in “&” between the range addresses. The only thing that would make this awesome would be the ability to concatenate an entire range. That would be way more useful than having to comma separate each cell that you want to concatenate.