Text Functions in Ms-Excel

In this video we can discuss about Text Functions or Formulas in our Excel Sheet.

1. CHAR ():-

It returns the character specified by the code number from the character set for your computer.

Syntax:- 

=CHAR (number)

2. CODE ():-

It returns a numeric code for the first character in a text string in the computer.

Syntax:- 

=CODE ("text")

3. LEFT ():-

It returns the first character.

Syntax:-

=LEFT("text", number char)

4. RIGHT ():-

It returns the last character

Syntax:-

=RIGHT("text",numberchar)

5. LENGTH ():-

It returns the number of characters in a string

Syntax:-

=LEN ("text")

6. UPPER ():-

It returns only upper case letters.

Syntax:- 

=UPPER ("text")

7. LOWER ():-

It returns only lower case letters.

Syntax:- 

=LOWER ("text")

8. PROPER ():-

It returns only proper word

Syntax:- 

=PROPER (“text”)