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 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 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 consolidate text by a condition in Excel

How to consolidate text by a condition in Excel

In this article, we are going to show you how to consolidate text by a condition in Excel. Download Workbook Please note that we will be using the new dynamic array functions UNIQUE and FILTER in this post. These functions currently are only available to Office 365...
Excel TEXTJOIN and CONCAT

Excel TEXTJOIN and CONCAT

Excel TEXTJOIN and CONCAT functions are relatively new, and welcome additions to Excel’s plethora of functions. Both functions have been released with Excel 2016 as a replacement for the CONCATENATE function to make it easier to merge multiple text strings. In this...
CONCAT vs CONCATENATE

CONCAT vs CONCATENATE

For a long time, the only option to combine text strings has been using the CONCATENATE function, which does nothing more than what the ampersand (&) operator does. Recently, Microsoft has released the CONCAT and TEXTJOIN formulas with Excel 2016. In this guide,...