It has always seemed strange to me that the Excel function Concatenate(), which has such a long name, provides no additional functionality over using the & operator.
The TextString function is a simple User Defined Function (UDF) which provides the following additional features:
- The cells to be concatenated are defined as a single row range, rather than separate cells.
- An optional separator character may be specified.
- Numbers, including dates, times and currency are concatenated as displayed
A spreadsheet including full open source code and examples may be downloaded from: TextString.xls
Typical output (and results of the Concatenate function) are shown in the screen shot below:
Pingback: Daily Download 32: Text functions | Newton Excel Bach, not (just) an Excel Blog
This is a really helpful UDF. But is there a reason it only works with a range of columns and not a range of rows?
Rob – no good reason, other than making it a bit simpler.
It now works on a single column range as well.
That’s great. Thanks
Pingback: Binary functions, combining text, and finding unique columns | Newton Excel Bach, not (just) an Excel Blog