Excel text functions are useful for modifying, managing, and manipulating text string data in Microsoft Excel. This page provides details on Excel text functions.

LEFT – returns a text string from the start (left side) of a text string

RIGHT – returns a text string from the end (right side) of a text string

MID – returns a text string from the middle of a text string

CONCATENATE – Combines multiple text strings into a single text string

LEN – returns the number of characters in a text string

SEARCH – returns the position of a text string within another text string

TRIM – removes spaces from the beginning and end of a text string and duplicate spaces

LOWER – returns a text string changed to all lower case characters

UPPER – returns a text string changed to all upper case characters

TEXT – converts a value into a text string

VALUE – converts a text string into a value