Excel 2024: Get the Countries from a Column of Phone Numbers

January 21, 2025 - by Bill Jelen

Someone had a long list of international telephone numbers. They asked if there is a formula to figure out the country from the phone number. It turns out that Country Codes are complicated. Some are a single digit. Some are 2 or 3 digits. Sometimes, two countries have the same country code and then you have to look at the country code plus area code to figure out, for example, if it is the USA or Canada.

More Reading

Excel 2024: Stale Value Formatting »

January 16, 2025 - by Bill Jelen

The Excel team added Stale Value Formatting in late 2023. The idea is that you might be working in a workbook with Manual Calculation enable. The strike-through formatting will remind you that certain cells need to be re-calculated.

Excel 2024: See Intermediate Calculations »

January 13, 2025 - by Bill Jelen

My friend Mike Girvin at the ExcelisFun YouTube channel has a great trick when explaining a long formula. Mike will select part of the formula in the formula bar and press F9 to calculate just that part of the formula. It is a cool trick, but you must remember to press Escape or you will hard-code the intermediate results in the formula.

Excel 2024: Check Performance in Excel »

January 9, 2025 - by Bill Jelen

A new feature debuted in 2023. Go to the Review tab and choose Check Performance. If you have a workbook that you've been using for years, you should check performance. It looks for excess formatting, unused cell styles, unneeded metadata that can slow your workbook down.

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

December 2021

Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions.

Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

April 2022

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful.

Your Excel Survival Kit - Second Edition

March 2021

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

Financial Modelling in Power BI

September 2022

The only book to produce all three financial statements in Power BI.

see more products »

Excel 2024: Get the Countries from a Column of Phone Numbers

More Reading

Featured Products