|
Running Case-IT for the First Time
To run Case-IT, proceed to the EMAGENIT toolbar
and click the Case-IT button. In Excel 2007,
proceed to the Add-Ins tab and click Case-IT.
The program will prompt you with two screens,
follow the instructions. On the second screen
which is the Information screen, leave the
Case-IT product ID box blank to run the program in demo
mode. The program will allow you to click the
"Change Button" 20 times before
prompting for a Case-IT product ID which can be
purchased from EMAGENIT.
Case-IT Introduction
Case-IT allows you to select worksheet ranges
then change the case of the text in the range.
With Case-IT, you can change a cell’s text to
upper, lower, sentence and title case. You can
also toggle the case of the text in a cell and
even clean your text of unwanted spaces and
characters.
How
to Open and Launch Case-IT in Microsoft
Excel
To open Case-IT in Microsoft Excel, go to the
Windows start button and click it, select the
EMAGENIT grouping under programs, click on the
Case-IT icon and it will open in Microsoft
Excel. If prompted, click the Enable Macros
button to enable the program. Once open in
Excel, proceed to the EMAGENIT toolbar in Excel
2003 and below and click the Case-IT button. In
Excel 2007, proceed to the Add-Ins tab and click
the Case-IT button.
How to Enable Macros in Microsoft Excel
(Case-IT Not Running)
If Case-IT will not run in Microsoft Excel and
prompts you as such, your macros have been
disabled. To enable macros, proceed to Microsoft
Excel Help and type in Enable Macros and follow
the instructions about enabling macros. Note
that you will have to shut down Excel and
re-launch Case-IT in most instances after
adjusting these settings. Note that Case-IT
cannot override Microsoft Macro security so
there is no way for our program to control this
feature and enable it for you. If it could be
done, we would have done it for you.
How to Purchase and Activate Case-IT
Case-IT automatically prompts you to purchase it
after clicking the "Change Button" 20 times by redisplaying its setup
Information screen. You can purchase the
software by clicking the purchase button on the
screen then clicking the purchase button on the
website page that is displayed. EMAGENIT will
send you the product-ID within 3 hrs during our
operating hrs Mon-Fri 8:00 AM-4:00 PM PST. You
can also purchase it by clicking on the Purchase
button to the left. To key in the product-ID,
just launch Case-IT and type the ID in the
Information screen in the Product-ID box at the
bottom.
How to Change the Case of Your Text
To change the case of your text in a worksheet
cell or range:
1. Activate Case-IT by clicking the Case-IT
button on the EMAGENIT toolbar or on the Add-Ins
ribbon.
2. Select the worksheet range(s) containing the
data you wish to scan. To select multiple ranges
at once, hold down the Ctrl key while clicking
on them. Note that the Undo feature will not
work on a cell selection of more than 2000
cells. This is a memory constraint.
3. Select the desired case option in the Case
options section.
4. If you wish to trim unwanted spaces and
characters from your text, check the appropriate
Cleaning section check box.
5. Check the Overwrite checkbox in the Scan
section if you want to replace worksheet
formulas with their text answer. If this box is
not checked, cells containing worksheet formulas
will be ignored by Case-IT.
6. Click the Change button to change the case
of the cell values.
*Note that you can keep Case-IT open while you
maneuver around Excel.
*Note that if a cell has a generated error value
from a formula, Case-IT will ignore it.
What Case-IT Skips in Sentence Case Mode
When the Sentence case option is selected, Case
it is designed to scan through the text from a
cell’s value and capitalize the beginning
character after every period. However Case-IT
ignores inc., i.e., e.g. and etc…. Case-IT will
also capitalize acronyms however the first
character may be skipped. Case-IT will ignore
characters that are already capitalized.
How to Close Case-IT
Case-IT closes when Microsoft Excel closes and
does not reopen with it. This is by design. To
close Case-IT so it is no longer present in
Excel without closing Excel, just check the Quit
check box at the bottom of its screen then click
the Close button. This will remove Case-IT from
Excel. |
