[HW 2.3d] VBA Concatenation

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:

concat

Add a comment section to this VBA function and save it to your custom function add in.

Advertisements

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

%d bloggers like this: