MS Excel text strings functions

Function name

Description

Example

CHAR(number)

Return character of given number, ex

 =char(65), A

CONCATENATE(text1, text2)

 Append text2 after text1

 

exact(text1, text2)

 Match two string for equality (it is case sensitive)

 

find(text_to_find, text_on_search, number)

 Return position of string and it is case sensitive

 

left(text, numbers)

 Return n characters from left

 

len(text)

 Return length of a text.

 

right(text, n)

 Return n characters from right

 

lower(text)

 Return lower case of given text

 

mid(text,start_num, number_of_characters)

 Return text from given start number to number of characters

 

proper(text)

 Return in capitalize form(first letter in upper case of each word in given text)

 

replace(old_text, start_num, num_chars, new text)

 Replace new text in the place of old text from given position

 

search(text_to_search, text_on_search, start_num)

 Search given text within a text from specified position and it is not case sensitive.

 

substitute(text, old_text, new_text)

 Replace new text in the place of old text on text.

 

trim(text)

 Remove all the spaces from the text

 

upper(text)

 Convert text into upper case.

 

© 2016 - 2022, All Rights are Reserved.