by Ilker | Dec 18, 2018 | Excel Formulas
Excel SEARCH function returns an integer that represents the position of a specified character or substring within a text. In this guide, we’re going to show you how to use the Excel SEARCH function and also go over some tips and error handling methods. Supported...
by Ilker | Dec 18, 2018 | Excel Formulas
Excel FIND function returns an integer that represents the position of a specified character or substring, within a text. In this guide, we’re going to show you how to use Excel FIND function, and also go over some tips and error handling methods. Supported versions...
by Ilker | Nov 26, 2018 | Excel Formulas, Resources
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, Resources
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 Excel RIGHT function and also go over some tips and error handling methods. Supported versions All Excel...
by Ilker | Nov 26, 2018 | Excel Formulas, Resources
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 19, 2018 | Excel Formulas, Resources
Excel DATEVALUE function returns a date serial number from a specified date that is stored as text. This function comes in handy when your dates are stored as text data, instead of Excel’s date number format. In this guide, we’re going to show you how to use the...
by Ilker | Nov 19, 2018 | Excel Formulas, Resources
The DATE function in Excel returns a date serial number from specified year, month and day values. In this guide, we’re going to show you how to use the DATE function and also throw in some tips and error handling methods. Supported versions All Excel versions Date...
by Ilker | Nov 13, 2018 | Excel Formulas
The Excel YEAR function returns the year from a specified date serial number. In this guide, we’re going to show you how to use this function and also go over some tips and error handling methods. Supported versions All Excel versions Excel YEAR Function Syntax...
by Ilker | Nov 13, 2018 | Excel Formulas
The Excel MONTH function returns the month from a specified date serial number. In this guide, we’re going to show you how to use the this function and also throw in some tips and error handling methods. Supported versions All versions Excel MONTH Function Syntax...
