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