by Ilker | May 9, 2019 | Excel Formulas
The TRANSPOSE Excel function is a Lookup & Reference formula that rotates a given range or array. Since the output of this formula is an array, you need to press the Ctrl + Shift + Enter (CSE) key instead of just pressing the Enter key when entering this function....
by Ilker | May 7, 2019 | Excel Formulas
The CONCATENATE Excel function is a Text formula that joins multiple strings together. You can enter static strings and individual cell references. In this guide, we’re going to show you how to use the CONCATENATE Excel function and also throw in some tips and error...
by Ilker | May 7, 2019 | Excel Formulas
The TEXTJOIN Excel function is a Text formula that joins strings together with a delimiter. You can enter static text strings, a range of cells, and individual cell references to join. In this guide, we’re going to show you how to use the Excel TEXTJOIN function and...
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 26, 2019 | Excel Tips & Tricks
The dreaded error message that says that your Excel workbook is corrupted can be intimidating. But fear not! There are a few things you can do to recover your work, or at least extract some of it and save yourself some time. In this guide, we’re going to show you how...
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...