Excel has many functions to offer when it comes to manipulating text strings.
Join Strings
To join strings, use the & operator.
Note: visit our page about concatenating strings for more information and examples.
![Join Strings Join Strings](https://www.excel-easy.com/functions/images/text-functions/join-strings.png)
Left
To extract the leftmost characters from a string, use the LEFT function.
![Left Function Left Function](https://www.excel-easy.com/functions/images/text-functions/left-function.png)
Right
To extract the rightmost characters from a string, use the RIGHT function.
![Right Function Right Function](https://www.excel-easy.com/functions/images/text-functions/right-function.png)
Mid
To extract a substring, starting in the middle of a string, use the MID function.
Note: started at position 5 (p) with length 3.
![Mid Function Mid Function](https://www.excel-easy.com/functions/images/text-functions/mid-function.png)
Len
To get the length of a string, use the LEN function.
Note: space (position 8) included!
![Len Function Len Function](https://www.excel-easy.com/functions/images/text-functions/len-function.png)
Find
To find the position of a substring in a string, use the FIND function.
Note: string "am" found at position 3. Visit our page about the FIND function for more examples.
![Find Function Find Function](https://www.excel-easy.com/functions/images/text-functions/find-function.png)
Substitute
To replace existing text with new text in a string, use the SUBSTITUTE function.
![Substitute Function Substitute Function](https://www.excel-easy.com/functions/images/text-functions/substitute-function.png)