by Ilker | May 6, 2019 | Excel Formulas
The CONCAT is a Text function that joins strings together. When using concatenate in Excel, you can enter static strings, a range of cells to join, and individual cell references. In this guide, we’re going to show you how to use the CONCAT function to merge cells in...
by Ilker | Apr 25, 2019 | Excel Formulas
The Excel REPLACE function is a Text formula that replaces any text in a specific location with another. You can obviously use Excel’s Find & Replace tool to do this, but a formula approach will give you more options as to how you can handle this, and also...
by Ilker | Apr 25, 2019 | Excel Formulas
The Excel SUBSTITUTE function is a Text formula that substitutes a text string with another. In this guide, we’re going to show you how to use the Excel SUBSTITUTE function, and also go over some tips and error handling methods. Supported versionsAll Excel...
by Ilker | Apr 25, 2019 | Excel Formulas
The Excel HYPERLINK formula is a Lookup & Reference function that can establish a connection to an external source such as a specific website, location in the document, or a different document. In this guide, we’re going to show you how to use the Excel HYPERLINK...
by Ilker | Apr 24, 2019 | Excel Formulas
The Excel LARGE function is a Statistical formula that returns largest value in an array or a range. In this guide, we’re going to show you how to use LARGE function and also go over some tips and error handling methods.Supported versionsAll Excel versionsExcel LARGE...
by Ilker | Apr 24, 2019 | Excel Formulas
The Excel SMALL function is a Statistical formula that returns the smallest value in an array or a range. In this guide, we’re going to show you how to use the Excel SMALL function and also go over some tips and error handling methods. Supported versionsAll Excel...
by Ilker | Apr 19, 2019 | Excel Formulas, Excel Tips & Tricks
Filtering data helps focusing on certain aspects of a data set. Excel has built-in features for this, an Excel formula for filtering data was not in the software’s scope until the introduction of dynamic array functions. In this guide, we’re going to show you...
by Ilker | Apr 17, 2019 | Excel Formulas
The Excel TRIM function is a Text formula which can remove the leading and trailing sections of a text string, and replace extra spaces between words with one. As the name suggests, the formula essentially “trims” the extra spaces in the target string, and...
by Ilker | Apr 17, 2019 | Excel Formulas
The Excel LEN function is a Text formula that returns the number of characters in a given string. In this guide, we’re going to show you how to use the Excel LEN function and also go over some tips and error handling methods. Supported versionsAll Excel versionsExcel...
