Function: DAY

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 Syntax...
Function: PROPER

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 versionsAll Excel...
Function: LOWER

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 versionsAll Excel versionsSyntax LOWER(text)ArgumentstextThe text you want converted...
Function: UPPER

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 versionsSyntax UPPER(text)ArgumentstextThe text you want converted to...
How to allow Excel uppercase characters only

How to allow Excel uppercase characters only

It’s often a good idea to use Data Validation feature to limit user errors and streamline data entry process. In addition to built-in rules, like size of a number or length of a text, you can define your own rules in a Custom fashion. Let us show you how to allow...
How to prevent Save As with VBA

How to prevent Save As with VBA

This article shows you How to prevent Save As with VBA.You can control your workbook’s events like opening, closing or saving by VBA. Events for Excel’s native objects are built in and ready to use. To prevent Save As event, the address is Workbook...
Function: IF

Function: IF

The IF function performs a logical test (specified from its first argument), and returns either one of its second or third argument depending on the result of the test. If the test returns TRUE, the result will be the second argument, otherwise it will be the third....