by Ilker | Feb 19, 2021 | Excel Tips & Tricks
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...
by Ilker | Feb 18, 2021 | Excel Tips & Tricks
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...
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 | 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 the...
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 you...
by Ilker | Sep 2, 2019 | Excel Tips & Tricks
You can easily increase the column width to fit more contents into a smaller area. However, increasing the column width means that you’re going to be able to use fewer columns. Changing the alignment of the text can help overcome these limitations and allow you...
by Ilker | Jul 8, 2019 | Excel Formulas
The Excel ISNONTEXT function is an Information formula that returns TRUE if the input value is a not text value, and FALSE otherwise. You can test the result of a formula or value of a cell using this function. This formula can be especially useful in organizing data,...
