|
Text Manager
- designed just for you!
The Text Manager
will make working with text in your spreadsheet very easy. It
is particularly useful for text which has been imported into
Excel. You specify the range to affect, this can be specified
cells or the entire sheet.
The Remove
Character or Text can save you many hours of manually
removing specific characters, or text, from specified text.
You can even copy the characters to remove directly from the
Windows Character Map. If the character or text you wish to
remove is not available, simply check the Specify Character
or Text option.
One very common problem with text (particularly imported
text) is the unavoidable importing of spaces. Not only does
this make your text unsightly and hard to read, but it can
also prevent:
- Numbers not being seen as
true numbers.
- Dates not being seen as
true dates.
- Hard or impossible to
break up text.
- Hard or impossible to
reference text.
- Hard or impossible to use
text in formulas.
The Change Case lets you instantly change the case of your
text. You can nominate to change your text to:
- UPPER CASE
- lower case
- Proper Case.
|
|
