Text/String Functions in Excel

Text/String Functions in Excel

This function is used for tact. Therefore they are called tact function. This is the following.1. UPPER (): - This function converts lower case letter to upper case.

Syntax:- =UPPER(TEXT)
Example:- UPPER(“Cyber Dairy Solutions”)
Result:- CYBERDAIRY SOLUTIONS

2. LOWER (): -  This function converts the upper case letter to lower case letter.

Syntax:- =LOWER(TEXT)
Example:- LOWER(“COMPUTER HINDI”)
Result:- computer hindi

3. Proper (): -  This sets the function text to proper case.

Syntax: =proper(TEXT)
Example:- proper(“COMPUTER HINDI”)
Result:- Computer Hindi

4. Len (): -  This counts the letters of the function text.

Syntax: =len(TEXT)
Example:- len(“Computer”)
Result:- 8

5. left (): -  This function extracts the letters of the word from the left side. Tact and how many letters to remove in it. Its number has to be given.

Syntax: =Left(TEXT, Number)
Example:- Left(“Computer”,3)
Result:- Com

6. Right (): -  This function extracts the letters of the word from the right side. Tact and how many letters to remove in it. Its number has to be given.

Syntax: =Right(TEXT, Number)
Example:- right(“Computer”,2)
Result:- er

7. TRIM (): - This function eliminates the space behind the front of the tactic.

Syntax: =Trim(TEXT)
Example:- trim(“   Computer ”)
Result:- Computer

8.MID (): - This function extracts  words from between the letters. In this, the letter has to be extracted from the tact and where as an argument. And how many letters to remove. Let's give his number.

Syntax: =MID(TEXT,START NUMBER , END NUMBER)
Example:- mid(“SUPER COMPUTER”,6,7)
Result:- COMPUTER

About Admin MC3

This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.

Related Post