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

Using Cell Formatting Logic With Excel Formulas

Using Cell Formatting Logic With Excel Formulas

Have you ever had a time where you wished you could write an IF formula in Excel based on whether or not a cell was filled with the color green or not? Unfortunately, Excel doesn't have a built-in "IsGreen" function you can call to perform such logic. However, with the power of VBA you can write your own functions and actually call them from the Formula Bar! 

Read More