Function: LEFT
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...
Function: DATEVALUE
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...
Function: DATE
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 versionsAll Excel...
Function: YEAR
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 versionsAll Excel versionsExcel YEAR Function...
Function: MONTH
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 [box...
Function: DAY
The DAY function in Excel returns the day from a specified date number. In this guide, we’re going to show you how to use this function and also include some tips and error handling methods.Supported versionsAll Excel versionsDAY Function in Excel...
Function: PROPER
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...
Function: LOWER
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 Arguments text...
Function: UPPER
The UPPER function converts a text into uppercase. In this guide, we’re going to show you how to use this function and cover some tips and error handling methods.Supported versionsAll Excel versionsSyntaxArgumentstextThe...