Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 27 of 60 · 540 articles
How to split text with Power Query in Excel
In this guide, we're going to show you how to split text with Power Query in Excel.
How to disable protected view mode in Excel
In this guide, we're going to show you How to disable protected view mode the infamous yellow band above formula bar in Excel.
How to split text with VBA in Excel
In this guide, we're going to show you how to split text with VBA in Excel.
How to split text with formulas in Excel
In this guide, we're going to show you how to split text with formulas in Excel.
How to count a specific character in a string in Excel
Learn how to count a specific character in a string in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to reverse a text string in Excel
Learn how to reverse a text string in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to open VCF format in Excel
In this guide, we're going to show you how to open VCF (Virtual Contact File) format, also known as vCard, in Excel with Text Import Wizard.
How to calculate median by criteria in Excel
Learn how to calculate median by criteria in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to run macro at a specified time in Excel
In this guide, we're going to show you how to run macro at a specified time in Excel.