Excel functions

PROPER Function in Excel - formula returns the first letter in a text string or cell references of every word as capital letter and all other to lowercase.

UPPER Function in Excel - formula converts all lowercase letters in a text string or cell reference to uppercase. Learn more Formulas, Excel and VBA .

LOWER Function in Excel - formula converts all uppercase letters in a text string or cell reference to lowercase. Learn Formulas, Excel and VBA examples

FIND Function in Excel - formula returns the location or position of a sub-string in a text string. Learn Formulas, Excel and VBA in our free tutorials.

CONCATENATE Function in Excel - formula is used to combine text from two or more cells into one cell. Learn Formulas, Excel and VBA in our free tutorials.

TIMEVALUE Function in Excel: Formula to converts a time represented by text to a serial number for a time. Learn Formulas, Excel and VBA with examples.

DAY Function in Excel - Formula to returns the day of the month represented by a serial number. Learn more Formulas, Excel and VBA with examples explained.

MONTH Function in Excel- Formula to returns the month of a date. Learn more Formulas, Excel and VBA concepts with examples explained in our free tutorials.

YEAR Function in Excel - formula to returns the year of a date. Learn more Formulas, Excel and VBA concepts with examples explained in our free tutorials.

SECOND Function in Excel - formula to returns the second , a number from 0 to 59. Learn Formulas, Excel and VBA with examples in our free tutorials.

MINUTE Function in Excel - formula to returns the minute , a number from 0 to 59. Learn Formulas, Excel and VBA with examples in our free tutorials.

HOUR Function in Excel - formula returns the hour as a number from 0 to 23. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.

DAYS360 Function in Excel - formula returns the number of days between two dates based on a 360 day year. Learn Formulas, Excel and VBA with examples.

DATEVALUE Function in Excel - formula Converts a date represented by text to a serial number for a date. Learn Formulas, Excel and VBA with examples .

What is the use of TIME function? Returns the number that represents the particular time What is the syntax of TIME function? TIME(hour, minute, second) Where hour: It is a number from 0 to 23 representing the hour minute: It is a number from 0 t0 59 representing the minute second: It is a number

DATE Function in Excel - formula returns the number that represents the particular date. Learn Formulas, Excel and VBA with examples in our free tutorials.

SUBSTITUTE Function in Excel - formula replaces old text with new text, in a text string or cell reference. It will replace all instances of the old text, unless a specific instance number is selected.

COLUMN Function in Excel - formula returns the column number of the given reference. Learn Formulas, Excel and VBA with examples in our free tutorials.

ROW Function in Excel - fromula returns the row number of the given reference. Learn Formulas, Excel and VBA concepts with examples in our free tutorials.