All articles with 'code' Tag
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 1.)
![Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 1.)](https://chandoo.org/wp/wp-content/uploads/2013/07/FC01Head2.png)
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.
Continue »![Cleaning Up Imported Data – A Recent Case Study](https://chandoo.org/wp/wp-content/uploads/2012/01/CudMaster.png
)
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](https://chandoo.org/img/a/twitter-client-excel.png)
Learn how you can write your own twitter client using Excel. All it takes is excel, internet connection and 5 minutes of spare time.
Continue »