Page 52 - COMPUTER

➢ Right (String, Number) :- It Returns The Specific Number Of Character From The Right
Side Of A Text String.

Example:- =Right (“Aarohan”,4)
=Right(D5,4)
D5=Furkan
➢ Mid (String, Start Number, Number Of Character):- It Returns A Specified Number Of
Character / String From A Specified Position In A Text String.
Example :- = Mid(“Reyaz”,3,3) Yaz
=Mid(“Muskan”,4,3) Kan
➢ Length (String) :- It Returns The Length Of A Text String .
Example :- =Len (“Aarohan”) 7

➢ Proper (String):- It Returns The First Character Of Each Word In A Text String To Upper
Case.
Example:- =Proper(“Aarohan Ngo”) Aarohan Ngo

➢ Upper (String) :- It Converts All Lower Case Letter In A Text String To Upper Case

Example :- =Upper(“Aarohan”) Aarohan

➢ Lower(String) :- It Converts All Upper Case Letter In A Text String To Lower Case .
Example :- = Lower(“Aarohan”) Aarohan

➢ Rept(String, Number):- It Repeats The Given Text String In Specified Number Of Times.
Example :- =Rept(“Aarohan”,5)
Aarohan Aarohan Aarohan Aarohan Aarohan
➢ Conactenate(Text1,Text2...) :- It Joins Several Text Items Into One Text Item.
Example :- =Concatenate(“Aarohan”,”Ngo”)

Aarohanngo
➢ Exact(Text1,Text2..):- It Compare Two Text Strings And Returns True If Match
Otherwise False.
Example :- =Exact(A2,E15) True
A2=Ram
E15=Ram
=Exact(“Reyaz”,”Reyaz Khan”) False

51