String/Text Functions

Below listed are the various string / text functions of Microsoft Excel 2007.

Asc():

ASC function changes the given double-byte characters to single-byte characters.

Bahttext():

BAHTTEXT function converts the given numbers to baht text.

Char():

CHAR function is used to convert a number to ANSI character

Clean():

CLEAN function is used to remove any non-printable characters from the given text.

Code():

CODE function is used to return the ANSI code of the given character.

Concatenate():

CONCATENATE function is used to join two or more texts into a single text.

Dollar():

DOLLAR function is used to convert the given number to currency, formatted as text.

Exact():

EXACT function is used to find if the given two texts are exactly the same.

Find():

FIND function is used to find the position of a specific letter in the text.

Fixed():

FIXED function is used to convert the given number to text.

Left():

LEFT function is used to return the specified number of characters from the left hand side of the content.

Len():

LEN function is used to find the number of characters in a given text.

Lower():

LOWER function is used to convert the given text to the lower case.

Mid():

MID function is used to pick characters from the middle of the given text.

Proper():

PROPER function converts the first letter of all the given words to upper case and the other letters to lower case.

Replace():

REPLACE function replaces a part of the text with a different text.

Rept():

REPT function repeats the given text number of times mentioned in the function.

Right():

RIGHT function returns the specified number of characters from the right hand side of the text.

Substitute():

SUBSTITUTE function replaces a part of text with another text.

T():

T function checks whether the given entry is text or not.

Trim():

TRIM function removes all the extra spaces from the given text.

Upper():

UPPER function converts the given text to the upper case.