Text formulas:

• A. Replace cell references
• B. Return ASCII values of characters
• C. Concatenate and manipulate text
• D. Show formula error value