1. =CHAR()
    This function is use to return a character equivalent with ASCII (American Standard Code for Information Interchange). (Note: We can given value from 0 to 255.)



2. =CODE()
    This function returns ASCII code of a given character.



3. =len()
    This function is use to return to the length of a string.



4. =left()
    This function returns n number of character of left side of string.



5. =right()
    This function return n number of character of right side of string.



6. =lower()
    This function is use to convert to lower case.



7. =upper()
    This function is use to convert to upper case.



8. =proper()
    This function is use to convert First letter of word to upper case.



9. =find()
    This function get the location of text in a string. It is case sensitive





10. =mid()
    This function is use to return the sub-part from the given string.



11. =replace()
    This function is use to move odd text and add new text on that place.



12. =exact()
    This function returns either true or false after comparing two string. (case sensitive)



13. =substitute()
    To replace existing text with new text in a string, use the SUBSTITUTE function.