Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 1.)
This new series introduces a new author to Chandoo.org, Jeff.
Jeff will pose a number of Excel based Formula Challenges and then explain how some of the solutions work in a manner similar to the Formula Forensics series.
In this first post of the series we look at how to extract a string from the right of a block of Numbers in a larger string.
Cleaning Up Imported Data – A Recent Case Study
Houston, We’ve Had a Problem!
In the initial emails requesting a solution to yesterday’s Formula Forensics, Chandoo’s solution, although Technically correct, Didn’t work ?
This post looks at the problem and what was wrong with the data causing the error.
Write Your Own Twitter Client using Microsoft Excel
Learn how you can write your own twitter client using Excel. All it takes is excel, internet connection and 5 minutes of spare time.