by Ilker | Nov 26, 2018 | Excel Formulas
The MID function returns a sub-string from a string, starting from a specified location. In this guide, we’re going to show you how to use the Excel MID function and also go over some tips and error handling methods. Supported versions All Excel versions Excel MID...
by Ilker | Nov 26, 2018 | Excel Formulas
The RIGHT function returns a sub-string from a specified string, starting from the right-most character. In this guide, we’re going to show you how to use the RIGHT function and also go over some tips and error handling methods. Supported versions All Excel versions...
by Ilker | Nov 26, 2018 | Excel Formulas
The LEFT function returns a sub-string from a specified string, starting from the left-most character. In this guide, we’re going to show you how to use the Excel LEFT function and also go over some tips and error handling methods. Supported versions All Excel...
by Ilker | Nov 12, 2018 | Excel Formulas
The PROPER function capitalizes the first letter of each word and converts the remaining letters into lowercase. In this guide, we’re going to show you how to use the this function and also go over some tips and error handling methods. Supported versions All Excel...
by Ilker | Nov 12, 2018 | Excel Formulas
The LOWER function converts a text to lowercase. In this guide, we’re going to show you how to use the this function and also go over some tips and error handling methods. Supported versions All Excel versions Syntax LOWER(text) Arguments text The text you want...
by Ilker | Jul 11, 2018 | Excel Tips & Tricks
This article shows how to replace character in Excel by position using REPLACE function. If you are looking to replace a specific character please refer to article How to replace a character. Syntax =REPLACE( text, start position of replacement, number of characters...
by Ilker | Jul 11, 2018 | Excel Tips & Tricks
Excel’s built in find and replace feature is fairly useful in most cases. But this can get tedious if you’re working with a large workbook or want to set this up dynamically. In this article we’re going to show you how to replace characters in Excel...
by Ilker | May 31, 2018 | Excel Tips & Tricks
This article shows how to count values by length based on their character count. This method can be helpful to check your data against invalid entries. It is also a good practice to use SUMPRODUCT and N functions together. Syntax =SUMPRODUCT(N(LEN(range)>character...
by Ilker | May 30, 2018 | Excel Tips & Tricks
Data formats differ by locations in the world. Once you understand the syntax of dates you can easily convert them from one locale to the other. In this article, we will cover the most standard date conversion in Excel: converting D/M/YYYY to M/D/YYYY. Syntax first...