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...
by Ilker | Oct 10, 2019 | Excel Tips & Tricks
If you want to remove file extension from full file names, first you need to locate the period (.) which separates the filename and the extension. This action is fairly easy to do if your file names do not contain any periods other than the extension separator....
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,...
by Ilker | May 15, 2019 | Excel Formulas
REPT is a Text function that repeats a string a given number of times. It is useful for filling a cell or fixed length of strings, as well as creating simple histograms. In this guide, we’re going to show you how to use REPT function and also go over some tips and...
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 | 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...
