Case-IT Online Help

Case-IT

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 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.

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.

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.

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 2 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.

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.

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.

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.