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

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

Syntax: = 

Example

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

Syntax: =

Example

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

Syntax: =

Example

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

Syntax:  =

Example

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

Syntax: =

Example

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

Syntax: =

Example

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

Syntax: =

Example

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

Syntax: =

Example

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

Syntax: =

Example

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

Syntax: =

Example

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

Syntax: =

Example

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

Syntax:=

Example

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

Syntax: =

Example

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

Syntax: =

Example

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

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

Syntax:= 

Example

 

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

 

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

Syntax:= 

Example

 

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

Syntax:= 

Example

 

6.20) LOWER: - change text case in lower case

Syntax: =

Example

 

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

Syntax: =

Example

 

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

Syntax: =

Example

 

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

 

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

 

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

Syntax: =

Example

 

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

Syntax: =

Example

Want More Basic Excel Deep Dives

©2020 by Pavan Lalwani. 

  • Udemy
  • Facebook
  • Twitter
  • YouTube
  • Linkedin