These 2 UDF’s will extract the first and last words using a formula in your worksheet. It is worth noting that during a data split such as this, the data you are working with may require a Trim() applied to it so any rogue trailing or leading spaces are removed, making the first word and […]
