Worksheet - Cell Tools
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,
-
UPPERCASE, or
-
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 (Add-in) is a must-have software for individuals that work with
Microsoft Excel Spreadsheets. Download JEM Plus and
discover cool new tools and functionality that will have a tremendous
impact on your productivity. Contains several robust utilities and
207 additional worksheet functions (mostly financial). JEM
Plus provides professionals and everyday users the power to get the most
out of their Microsoft Excel Spreadsheets.