by Ilker | Feb 17, 2021 | Excel Tips & Tricks
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...
by Ilker | Jan 6, 2021 | Excel Tips & Tricks
Data formatting can get mixed up when you open a data file with CSV format. In this article, we are going to show you how to avoid formatting change in CSV files in Excel. Download Workbook If you need to prevent numbers from changing into dates when entering data,...
by Ilker | Jan 5, 2021 | Excel Tips & Tricks
In this article, we are going to show you how to consolidate text with Pivot Table in Excel 2013 or newer. Download Workbook If you are using Office 365, also see our alternative approach for consolidating text in Excel. Thanks to the dynamic array functions like...
by Ilker | Jan 5, 2021 | Excel Tips & Tricks
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...
by Ilker | Dec 31, 2019 | Excel Tips & Tricks
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...
by Ilker | Dec 30, 2019 | Excel Tips & Tricks
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,...
by Ilker | Nov 25, 2019 | Excel Tips & Tricks
Data doesn’t always come in a nice table layout, especially, when you retrieve it from an external source like a web site. Thanks to the Excel Text to Columns feature, you can split data into multiple columns. In this article, we are going to show you how to use...
by Ilker | Oct 17, 2019 | Excel Tips & Tricks
Although Excel already has built-in sorting features, doing this with formulas might be useful in some cases for a more dynamic approach. The formula approach will be updated automatically whenever calculations are executed. In this article, we’re going to show...
by Ilker | Oct 16, 2019 | Excel Formulas
The Excel UNICHAR function is a Text formula that returns the Unicode character of a given numeric code. This function comes in handy when you need to insert special characters that are typically not found on a standard keyboard layout. In this guide, we’re going to...