# Robert Gascon’s Shortest Formula Challenge

Robert Gascon not only created a shortest formula challenge but he also challenged me to write a post about it! Continue reading

# Awkward Data

Another awkward dataset. Should we re-arrange the data or just find a way to calculate what we need? Continue reading

# Partial Match Count with a Condition

Once again I discovered a formula that I had written down in a notebook. What is it doing? Is there an easier way to solve this? Continue reading

# Largest Number Inside Alphanumeric String

A friend shared this challenge: extract the largest number from this text  as420lkjs09nsdk2324lkjsd099 !  The answer is 2324. How do we solve this? Formulas? VBA? Continue reading

# formula or vba to add spaces?

Add a space after each character in a cell. Excel expert Tom Urtis solved it with vba. I solved it using a formula. Let’s compare these methods. Continue reading

# Formulas or VBA to create military code?

How do you know whether you should use Excel Formulas or Excel VBA? Sometimes both work and sometimes only one works. This series will explore this question. Let’s start with an idea from Sumit Bansal at TrumpExcel. Continue reading