PROPER Function in Excel
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.
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.
OFFSET Function in Excel - formula returns a reference to a range of cells that is a specified number of rows and columns from an initial supplied range
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.