Microsoft Office Tutorials and References
In Depth Information
Figure 26-3: Calculating sales commissions based on sales amount and years employed.
The workbook, commission function.xlsm, shown in Figure 26-3, is available at this
Text Manipulation Functions
Text strings can be manipulated with functions in a variety of ways, including reversing the display of a text
string, scrambling the characters in a text string, or extracting specific characters from a text string. This section
offers a number of function examples that manipulate text strings.
This topic's website contains a workbook named text manipulation functions.xlsm that
demonstrates all the functions in this section.
Reversing a string
The following REVERSETEXT function returns the text in a cell backward: