Left: -It returns specified no of
character from the left of a text string.
Syntax: - =Left(“stringâ€, No. of character)
Ex: - =Left(“Computerâ€, 5)
Result: - Compu
Right:-It returns specified no of
character from the right of a text string.
Syntax: - =Right(“stringâ€, No. of character)
Ex:
- =Right(“Computerâ€, 5)
Result: - Puter
Mid: -It returns specified no of
character from the middle of a text string, given a starting position and
length.
Syntax: - =mid(“Stringâ€, Start, Position no of
character)
Ex: - =mid(“Computerâ€, 4, 3)
Result: - Put
Len: -It returns the length of a text
string.
Syntax: - =Len(“Stringâ€)
Ex: - =Len(“Computer Worldâ€)
Result: - 14
Proper: -It converts the first letter of
each word in a text string to upper case.
Syntax: - =Proper(“Stringâ€)
Ex: - =Proper(“computer worldâ€)
Result: - Computer World
Rept: -It is used repeat the given
string a specified no. of times.
Syntax: - =Rept(“Stringâ€, No. of times)
Ex: - =Rept(“Quantumâ€, 5)
Result: - Quantum Quantum Quantum Quantum Quantum
Upper: -It converts all lower case
letters in a text string to upper case.
Syntax: - =Upper(“Stringâ€)
Ex: - =Upper(“Computerâ€)
Result: - COMPUTER
Lower: -It converts all case letters in a
text string to lower case.
Syntax: - =Lower(“Stringâ€)
Ex: - =Lower(“COMPUTERâ€)
Result: - computer