Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Excel Cell Tools. Upper, Lower and Proper Case. Toggle Absolute/Relative


Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

BUY | JEM Plus Start

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:

  • Relative
  • Absolute
  • 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 Start

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

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

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