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: