DON'S MISS THESE
MS EXCEL FORMULAS - III
MicroSoft's excel has become must have skill for the tech aspirants.
Continuing daily use formulas from part 2...
LEN: Returns the number of characters in a string.
Syntax: =LEN(text)
TRIM: Removes extra spaces from a string.
Syntax: =TRIM(text)
PROPER: Capitalizes the first letter of each word in a string.
Syntax: =PROPER(text)
2.
UPPER: Converts all characters in a string to uppercase.
Syntax: =UPPER(text)
LOWER: Converts all characters in a string to lowercase.
Syntax: =LOWER(text)
DATE: Returns the serial number of a date.
Syntax: =DATE(year, month, day)
YEAR: Returns the year of a date.
Syntax: =YEAR(date)
MONTH: Returns the month of a date.
Syntax: =MONTH(date)
DAY: Returns the day of a date.
Syntax: =DAY(date)
CEILING: Rounds a number up to the nearest multiple of a specified value.
Syntax: =CEILING(number, significance)
Read more :
Don't miss these MS Excel Formulas Part 1
Read more :
How to earn from MS Excel
Read more :
Creative ways to use MS Excel and earn big
Read more:
Interview with ChatGPT
Read more:
Creative works done by ChatGPT try them..
Watch more