Excel Text Functions

TRIM Function

The TRIM function in Excel removes all extra spaces from text, leaving only single spaces between words, enabling the cleaning up of messy data in spreadsheets.

LEN Function

The LEN function determines the number of characters in a given text string, including letters, numbers, spaces, and special characters.

LOWER Function

The LOWER function in Excel is a text function that converts all the characters in a given text string to lowercase.

UPPER Function

The UPPER function is a text function in Excel that converts all the characters in a given text string to uppercase.

PROPER Function

The PROPER function in Excel capitalizes the first letter of each word in a cell and lowercase all other letters. It is used mainly to ensure consistent formatting.

TEXTJOIN Function

The TEXTJOIN function combines or joins multiple text strings from a range of cells into a single text string. A key feature is its ability to include a delimiter of your choice.

CONCAT Function

The CONCAT function in Excel combines or joins multiple text strings into one. It brings together separate pieces of data (like first and last names).

TRIM Function

LEN Function

LOWER Function

UPPER Function

PROPER Function

TEXTJOIN Function

CONCAT Function

Subscribe to our newsletter

Subscribe to our newsletter

Subscribe to our newsletter