Top 10 Excel formulas for IT people
Are you in IT & use Excel often? This article explains top 10 formulas for IT professionals. Useful for project managers, IT analysts, Testing people and BAs.
We cover a 10 practical situations and explore various Excel formulas to solve them. Example workbook provides more details too.
Formula Forensics 042: Reverse Text – A Formulaic Solution
Use the new Textjoin() function to reverse a string of characters suing a formulaic solution.
Export iPhone contacts to Excel using this free template
Recently my iPhone 4 crashed. It is 3.5 years old. And just like any other 3 year old, it started acting weird & crazy one night. The next morning it went silent. It won’t go beyond the Apple logo whenever I start it. Since I couldn’t wait for the phone to start, I took out the SIM card (the phone is unlocked, if you are wondering) and placed it in my old Nokia phone. But alas, none of my contacts are on the SIM. They are in “cloud”.
After a day of answering phone calls from everyone including my mom as “Chandoo here”, I’ve decided to get my contacts back. So I logged in to iCloud to download a backup. And the backup was a .VCF file.
Since I wanted to have all my contact numbers in a spreadsheet, I did what any Excel nerd would do. I built a template that can convert VCF data to Excel worksheet.
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 4.)
Welcome back to another gripping episode of “When good formulas go GREAT”. Just like the immortal combatants in the classic 1986 movie Highlander, over the last three posts in this series our Excel nerds have been locked in an ages-old battle to decapitate. A text-string, that is. Not each other. So far we have seen […]
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 3.)
Welcome back to yet another gripping episode of “When good formulas go GREAT”. We’re working up the singles charts to the number one hit “Formula Challenge 001 – Return everything in string after first block of numbers” By way of a quick refresher, this formula challenge calls for a formula to return a substring from […]
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 2.)
Today we look at the third place winner from our inaugural Formula Challenge, a neat solution provided by Sajan.
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.