Text Functions in Excel

By | June 7, 2019

Text Functions in Excel

Join Strings | Left | Right | Mid | Len | Find | Substitute

Excel has many functions to offer when it comes to manipulating text strings.

Join Strings

To join strings, use the & operator.

Join Strings

Note: to insert a space, use ” ”


To extract the leftmost characters from a string, use the LEFT function.

Left Function


To extract the rightmost characters from a string, use the RIGHT function.

Right Function


To extract a substring, starting in the middle of a string, use the MID function.

Mid Function

Note: started at position 5 (p) with length 3.


To get the length of a string, use the LEN function.

Len Function

Note: space (position 8) included!


To find the position of a substring in a string, use the FIND function.

Find Function

Note: string “am” found at position 3.


To replace existing text with new text in a string, use the SUBSTITUTE function.

Substitute Function

Hope this helps! Leave a comment if this post helped you or in case of any questions.