How to use Text Functions in Excel

0
424
Text Functions in Excel
Text Functions in Excel

Text Functions in Excel

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

READ HERE  Basic Home Wiring Plans and Wiring Diagrams

LEAVE A REPLY

Please enter your comment!
Please enter your name here