If you find it CODE outside, this function may assist you. CODE returns a numeric code (great dictionary definition) for the first character in a text string. The returned code corresponds to the character set used by your computer.

It’s a great feeling when you write an involved piece of code with grand loops that apply over thousands of rows. There’s a sweet sensation when you save the file, hit run, and watch your handiwork unfold in front of you… until the screen stops updating...

Welcome to our Power Query blog. Today I take a closer look at conditional columns...

On the final Friday of each month, set an Excel for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.

On the final Friday of each month, we’re going to set Excel for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights only...

In Excel(lent) Functions, I covered how to replicate some commonly used Excel functions. Readers will recall that although Power Query is an add-on for Excel, it does not always work in the same way....

Need to make a CLEAN getaway? This function removes all nonprintable characters from text. And I’m not talking about expletives...

Today we learn how to make something happen when you click on a cell...

Today we look at how to join columns of data when the data type does not match.

Do you choose to use CHOOSE? This function uses index_num to return a value from the list of value arguments...