Extract the Nth word in a String in Excel

Get Nth Word Excel Example

Visual Basics for Applications (VBA) allows users to build on the existing functionality of  Microsoft Excel. It comes with a strong set of inbuilt functions that are often not readily accessible from Excel’s interface. These functions have to be wrapped inside a user defined function to be usable in Excel. A classic example is the Split function.

Continue reading “Extract the Nth word in a String in Excel”

Advertisements

Concatenate a Range of Strings in Excel

Concatenate Range

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.

Continue reading “Concatenate a Range of Strings in Excel”