How to split text with Power Query in Excel

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. Download Workbook What is Power Query Power Query is a feature of Excel that makes access to data easier and manageable. If you...
How to disable protected view mode in Excel

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...
How to split text with VBA in Excel

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. Download Workbook Data In this example, we have rows of data...
How to split text with formulas in Excel

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...
How to count a specific character in a string in Excel

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. Download Workbook Syntax...
How to reverse a text string in Excel

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. Download Workbook Please note that as of we are writing this article, functions like TEXTJOIN and CONCAT are available for Excel 2019 and Microsoft 365 subscribers only. Syntax CONCAT...
How to open VCF format in Excel

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

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. Download Workbook To calculate median based on a criteria, you need to supply a range of values to be compared against the specific criteria defined in the MEDIAN function....
How to run macro at a specified time in Excel

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. Download Workbook Application.OnTime VBA’s Application.OnTime...