Text Function

6.1) CHAR:  - This function required number between 1 to 255 specifying which character you want. The character is from the character set used by your computer

Syntax:  =

Example

1.png
1.png

6.2) CODE: - This function returns the ASCII value of a character, this function return character number

Syntax: = 

Example

2.png
2.png

6.3) UNICHAR: - This function give you the Unicode characters from the Unicode number provided.

Syntax: =

Example

3.png
unichar.png

6.4) UNICODE: - This function give you Unicode of string/texts

Syntax: =

Example

unicode.png
3.png

6.5) CLEAN: - Remove non-printable characters (Non-printable Unicode characters include No. 1429,141,143,144 & 157)

Syntax:  =

Example

4.png
4.png

6.6) TEXT: - The easiest way to change number to text

Syntax: =

Example

5.png
5.png

6.7) NUMBERVALUE: - This function is use to change text value to number with decimal and group separators.

Syntax: =

Example

6.png
6.png

6.8) FIXED: - This function apply decimal points with prevent commas or do not prevent commas to any number,

Syntax: =

Example

7.png
7.png

6.9) DOLLAR: This function change the number to text with currency format with the decimals place round as per you specify.

Syntax: =

Example

8.png
8.png

6.10) T: - This function check the text/string

Syntax: =

Example

9.png
9.png

6.11) VALUE: - This function give you a numeric value

Syntax: =

Example

10.png
10.png

6.12) LEN: - This function use to counts characters, letters and space in the cells (Count the length of text)

Syntax: =

Example

11.png
11.png

6.13) LEFT: - This function is used to extract left side’s number of text

Syntax:=

Example

12.png
12.png

6.14) RIGHT: - This function is used to extract right side’s number of text

Syntax: =

Example

13.png
13.png
14.png

6.15) MID: - Return the character of given number from middle of a supplied text string

Syntax: =

Example

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
14.png
 

6.16) REPT: - This function give you repetitive text as per specified number to times.

Syntax:= 

Example

15.png
15.png
 

6.17) EXACT: - This function used for check or compare both text are same or not, consider upper and lower case also (Result in True or False)

Syntax: =

Example

16.png
16.png
 

6.18) CONCATENATE: - This function joint multiple character and values in on word

Syntax:= 

Example

17.png
17.png
 

6.19) TRIM: - This function remove unwanted starting and ending space

Syntax:= 

Example

18.png
18.png
 

6.20) LOWER: - change text case in lower case

Syntax: =

Example

19.png
19.png
 

6.21) UPPER: This function is used to change text case in capital (upper case)

Syntax: =

Example

20.png
20.png
 

6.22) PROPER: - This function is used to change text case in first letter in capital then small case.

Syntax: =

Example

21.png
21.png
 

6.23) FIND: - This function is use to find out text number within any word from starting position, consider upper & lower case also

Syntax: =

Example

22.png
22.png
 

6.24) REPLACE: - This function is used to replaces character specified by position in given text string with another text string

Syntax:= 

Example =Replace (“Vikas123”, 6, 3,”456”)     Vikas456

23.png
23.png
 

6.25) SEARCH: - This function returns a number value. The first position.

Syntax: =

Example

24.png
24.png
 

6.26) SUBSTITUTE: - This function is replace a group of string with another string.

Syntax: =

Example

25.png
25.png

Want More Basic Excel Deep Dives