This utility consists of a dialog box with three tabs (i.e., Add, Edit, and Delete). This utility allows users to apply multiple commands to one or more cells within one or more selected areas and then on one or more worksheets at the same time as the active workbook. This tools is a real time saver. The first tab allows users to add characters to the left or right of cell contents. The second option allows users to insert characters or numbers after an nth character. The second tab contains three features: Case, Reference, and Formulas.
The case feature changes cell contents to:
- Sentence. Case,
- lower case,
- Title Case
The Reference feature allows users to change formula to:
- Absolute Rows, Relative Columns
- Relative Rows, Absolute Columns
The Formula feature allows users to change:
- Formula to text
- Text to formula,
- and Unapply Names
The last tab provides a great deal of control when deleting certain characters and spaces within cell contents. At any time, the user can change the cells references without exiting the utility. When manipulating and cleaning up data, you definitely want to have this utility. Below is the screen shot of this utility.
JEM Plus (Excel Add-in) $49.95 Secure Payment Options
Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
See Also: Excel Add-ins Index & Excel Templates Index or, All Software
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS