Excel Tips and Tricks
How to split text with Power Query in Excel
Power Query is a data management tool in Excel. In this guide, we're going to show you how to split text with Power Query in Excel. [button link="https://spreadsheetweb.com/wp-content/uploads/2021/03/How-to-split-text-with-Power-Query-in-Excel.xlsx" type="big"...
How to disable protected view mode in Excel
Excel opens most files from other sources in Protected View mode by default. In this guide, we're going to show you how to disable protected view mode in Excel. Excel, like most other Office applications such as Word and PowerPoint, shows this message to ensure that...
How to split text with VBA in Excel
Text to Columns feature can help you split text strings in Excel. Using VBA, you can make this process even faster. In this guide, we're going to show you how to split text with VBA in Excel. [button...
How to split text with formulas in Excel
Excel has more than one way for splitting text, such as Text to Columns feature. However, the feature requires a manual user intervention. You can make the process dynamic with help of functions. In this guide, we're going to show you how to split text with formulas...
How to count a specific character in a string in Excel
In this guide, we're going to show you how to count a specific character in a string in Excel. Finding the number of a specific character, such as a delimiter, can help with splitting a text with the use of formulas. [button...
How to reverse a text string in Excel
In this guide, we're going to show you how to reverse a text string in Excel. Please...
How to open VCF format in Excel
VCF (Virtual Contact File), also known as vCard, is a file format for business cards that has been in use since 1996. A VCF is a text-based file format can store various information like the contact name, phone number, and email address. Although Excel does not have...
How to calculate median by criteria in Excel
In this guide, we're going to show you how to run calculate median by criteria in Excel. To...
How to run macro at a specified time in Excel
With Application.OnTime method, you can set Excel to run some VBA at a specific time, or repeatedly at set intervals. In this guide, we're going to show you how to run macro at a specified time in Excel. [button...