My First Microsoft Excel MVP Award!

My First Microsoft Excel MVP Award!

On July 1st, 2016 I received an email from Microsoft congratulating me on being awarded the Microsoft Excel MVP award for 2016. I was the only new person in the Excel category to receive the award out of the list of winners and I had to reread the email quite a few times before my mind could accept that I was now officially part of an amazing group of Excel users from across the world.

Read More

Combining Text With The CONCAT and TEXTJOIN Excel Functions

Combining Text With The CONCAT and TEXTJOIN Excel Functions

There are a variety of reasons why you might want to combine various cell values into a single value. You might be trying to create a unique ID to perform a lookup or simply wanting to combine location information such as a city with a country. The Microsoft Excel developers have recognized the importance of joining our data inside of Excel and have finally added two more extremely useful functions that we can incorporate into our arsenal of text manipulating skills. In this article, you will learn the basics of combining text with these brand new functions and hopefully you gain some insight into how you can use them inside your spreadsheet work on a regular basis.

Read More