Kelly Jackson
@Kelly.Jackson · Updated 24 May. 2022

The text functions in Excel are useful for manipulating text to create new words, change the case of a word, and more.

The following is the list of the top seven most useful Microsoft Excel text functions:

• CONCATENATE

• LEFT

• LEN

• MID

• RIGHT

• SUBSTITUTE

• TRIM

Frank Lucas
@Frank.Lucas · Updated 24 May. 2022

Microsoft Excel is a powerful tool for working with text. It can be used to sort, filter, and format text.

Below are the top seven most useful Microsoft Excel functions for working with text:

• Text to Columns

• Text Functions: CONCATENATE, LEFT, RIGHT, MID,  

• Data Validation

• Conditional Formatting

• Text to Columns: Convert Text to Columns