If you want to manipulate text strings, Excel has many useful text functions to fulfill your needs.
Use the RIGHT function to extract most right character of a text string.
Syntax =RIGHT(text,[num_chars]) where num_chars (option) is numbers of character to extract, like 7 in our above example.
To extract left most character, use the LEFT function.
MID function is used to extract middle characters from a text string.
Use LEN function to get the length (number of character) of a text string.
Turn negative to positive
Use ABS function to turn negative values to positive.
CONCATENATE function is used to join different text strings.
Use CLEAN function for this.
EXACT function is used to compare different text strings or values and results with TRUE if strings are exactly same otherwise it will return FALSE.
Excel will show TRUE if both values match otherwise FALSE will appear.
For lower case letters
Use LOWER function to get all text strings with lower case letters.
SUBSTITUTE function is used to replace a specific text in a text string. For example, you can replace an article “a” with “the” in the text string.
Use TRIM function to remove irregular spaces between words.