Functions : 5 Text Functions

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 " "

Left

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

Right

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

Mid

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.

Len

To get the length of a string, use the LEN function.
Len Function
Note: space (position 8) included!

Find

To find the position of a substring in a string, use the FIND function.
Find Function
Note: string "am" found at position 3.

Substitute

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

No comments:

Post a Comment