Text Functions

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

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

Join Strings

We use the & operator to join strings.

Note: to insert a space, we used " "

Left

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

Right

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

Len

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

Note: space (position 8) included!

Find

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

Note: string "am" found at position 3.

Mid

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

Note: started at position 9 (t) with length 4.

Substitute

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

Did you find this information helpful? Show your appreciation, vote for us.

Go to Top: Text Functions    |    Go to Next Topic: Lookup & Reference Functions