Text Tools
The Text Tools utility provides several ways to manipulate text in selected cells without using formulas. You can:
- Change the case of the text (UPPER CASE, lower case, Proper Case,
Sentence case., and tOGGLE cASE).
- Add new characters to the text (at the beginning, at the end, or at a specified position).
- Remove characters from the text by position (from the beginning, from the end, or beginning at a specified position).
- Remove spaces from the text (all extra spaces, or all spaces).
- Remove characters of a particular type from the text (non-printing
characters, alpha characters,
non-numeric characters, non-numeric and non-alpha characters, or numeric characters).
Note: This utility will not preserve individual character formatting
in your cells (e.g., superscript formatting). Formatting applied to entire cells
is not affected.
See Also