Stringing more than two words together

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:

  1. The cells to be concatenated are defined as a single row range, rather than separate cells.
  2. An optional separator character may be specified.
  3. 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:

TextString Output, click for full size view

This entry was posted in Excel, UDFs, VBA and tagged , , , . Bookmark the permalink.

5 Responses to Stringing more than two words together

  1. Pingback: Daily Download 32: Text functions | Newton Excel Bach, not (just) an Excel Blog

  2. Rob says:

    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?

    Like

  3. Rob says:

    That’s great. Thanks

    Like

  4. Pingback: Binary functions, combining text, and finding unique columns | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s