Top 6 Function of MS office excel useful

1) .It is  Excel LOWER function returns a lower-case of a given text string. 

Convert text to Lower case.

Syntax:- =LOWER(TEXT) Enter
Example :- =LOWER(D3) Enter



2.) It is  Excel UPPER function returns a Upper-case of a given text string.It is all text convert to Upper case. 

Convert text to Upper case.

Syntax:- =UPPER(TEXT) Enter
Example :- =UPPER(D3) Enter



3.)  It is  Excel PROPER function returns a Proper-case of a given text string. It is first text of Proper case string.

Convert text to Proper case.

Syntax:- =PROPER(TEXT) Enter
Example :- =PROPER(D3) Enter



4.)It  Excel RIGHT function  a given number of characters from the right side of a text string. For example, RIGHT("orange",3) result "nge".

Syntex :-  =RIGHT(TEXT,NUM_CHARS) Enter

Example =RIGHT(D3,3) Enter



5.)It  Excel LEFT function  a given number of characters from the left side of a text string. For example, LEFT("mango",3) result "man".

Syntex :-  =LEFT(TEXT,NUM_CHARS) Enter

Example =LEFT(D3,3) Enter




6.) It Excel LEN function returns the length of a given text string as the number of characters. LEN will also count characters in numbers, but number formatting is not included.we can use easily formula of LEN.

Syntax :- =LEN(TEXT) Enter
Example :- =LEN(D3) Enter





https://www.youtube.com/watch?v=FHsEvT-UpDA&t=6s Watch and understand .How To Change Case of Text in Excel With Formulas Convert Text In UPPER, LOWER & PROPER Case