Formula and Text Manager for Excel
> FREE TRIAL DEMO
Formula and Text Manager for Excel
Author Company: OzGrid Business Applications
Formula and Text Manager for Excel FORMULA MANAGER:The Formula Manager is designed to make the managing of all
File Size: kB
OS: Windows 98 / NT / 2000 / ME / XP / VISTA
License: Shareware - Time Limit, free to try, to buy.
Software Developed by OzGrid Business Applications
Description :
Formula and Text Manager for Excel - FORMULA MANAGER:The Formula Manager is desig
The Formula Manager is designed to make the managing of all formulas a breeze. It can be used to map your spreadsheet by formula type. You can format the background color of all formulas that match the criteria you set. It a can also format the font of all formulas that match any criteria you set. Once applied, you can tell at a glance which cells contain formulas and which do not.
When you have a spreadsheet that contains formulas, you want to be sure that no user can delete, over-write or modify them. The Formula Manager can do this for you in seconds! Just specify which formula types to Lock, Hide or Lock and Hide. You can even protect the sheet in the same step! You can also easily Lock or Unlock all cells in one click.
The formula types you can specify for Formatting (font and/or background), Hiding and Locking are:
Referencing other Workbooks
Referencing other sheets in Workbook
Referencing active sheet
All types
The Formula Report Generator Allows you to very easily create a report showing formulas within your Workbook that are either external references, internal references or both. You can also nominate which Worksheet(s) to use to base your report on. The report that is generated contains, the formula as in the cell, the address of the cell and the sheet is resides on. Auto filter is also automatically applied for ease of reading.
Also included is a Formula Copy. This allows you to easily copy any formula range and paste it to a destination without any references changing. The option is the Transposing of formulas (row to columns and columns to rows) again, without any references changing.
File Size Reducer: FREE
TEXT MANAGER:
The Text Manager will make working with text in your spreadsheet very easy. It is particularly useful for text which has been imported into Excel. You specify the range to affect, this can be specified cells or the entire sheet.
The Change Case lets you instantly change the case of your text. You can nominate to change your text to all UPPER CASE, all lower case, or Proper Case.
The Remove Character or Text can save you many hours of manually removing specific characters, or text, from specified text. You can even copy the characters to remove directly from the Windows Character Map. If the character or text you wish to remove is not available, simply check the Specify Character or Text option.
One very common problem with text (particularly imported text) is the unavoidable importing of spaces. Not only does this make your text unsightly and hard to read, but it can also prevent:
- Numbers not being seen as true numbers.
- Dates not being seen as true dates.
- Hard or impossible to break up text.
- Hard or impossible to reference text.
- Hard or impossible to use text in formulas.
You can remove all Leading spaces, Trailing spaces, Trailing and Leading spaces, or All spaces, except for single spaces between words.
Have some text you wish to concatenate (link together)? The Text Manager can do this is quickly and easily. Simply specify the cells to concatenate, then specify the cell to concatenate the text into and click OK. Your text will instantly be joined. You can also tell the Formula Manager to add a space between each cell that is joined.
This is the Shareware version. The full version can be purchased by clicking on the "Buy Now" button below for around $ USD.
Click to buy from RegNow
![]()
![]()
![]()
![]()
![]()
Keywords: Formula and Text Manager for Excel demo: download Formula and Text Manager for Excel :Formula and Text Manager for Excel free download :Formula and Text Manager for Excel free download:Formula and Text Manager for Excel :Formula and Text Manager for Excel review :Formula and Text Manager for Excel review::: download Formula and Text Manager for Excel :
More Products from company OzGrid Business Applications :
- Time Sheet Advanced Deluxe - This extremely easy and simple to use Excel Time Sheet will keep track of your
- Time Sheet Deluxe - This extremely easy and simple to use Excel Time Sheet will keep track of your
- Number-Text - Formula Manager Deluxe - Number,Text & Formula Manager is 3 seperate Excel Add-ins bundled together to
- Forms ComboBox Wizard Add-in Deluxe - If you often work in Excel with ComboBoxes from the Forms toolbar this Excel
- Excel Manager Collection Deluxe - Duplication Manager, Number Manager,Text Manager, Named Range Add-in Manager &
- Excel Level 3 - Excel VBA - Excel UserForm Courses Deluxe - CURRENT SPECIAL Was $99.00 Now $49
- Excel Level 2 and 3 Training Deluxe - CURRENT SPECIAL Was $75.00 Now $39
- Excel Level 1- 2 and 3 Training Deluxe - Excel Level 1, 2 and 3 Training Buying the lessons in this bundle normally
- Time Sheet Advanced Open Source Deluxe - With this version the password for the Worksheets and the VBA code is supplied
- TimeAndWageBook - If you need to track employee hours and calculate their pay based on the hours
- Text Manager - The Text Manager will make working with text in your spreadsheet very easy
- OzGrid excel Addins Collection - The OzGrid Add-ins Collection contains all 7 of our Excel Add-ins
- NumberText Formula Manager - Number,Text & Formula Manager is 3 seperate Excel Add-ins bundled together to
- Number Manager - The number manager fills in the gaps in Excel when working with numbers
- Formula Ref Changer and Sheet Index Creator - Extremely handy add-in that will instantly change your formulae references from
- Excel and Excel VBA Tips and Tricks - 10 Day Money Back Guarantee.See 33+ Workbook Examples To Save Even More
- Excel VBA Level 1 and Excel UserForms - CURRENT SPECIAL Was $75.00 Now $59
- Excel OzGrid Plus With Duplication Manager - Formula Report Generator:Allows you to very easily create a report showing
- Excel Level 3 and Excel VBA Courses - CURRENT SPECIAL Was $75.00 Now $59
- Excel Level 3 Lessons - CURRENT SPECIAL Was $65.00 Now $49
- Excel Level 2 Lessons - CURRENT SPECIAL Was $65.00 Now $49
- Excel Level 1 2 and 3 Training - CURRENT SPECIAL Was $99.00 Now $79
- Excel Level 1 Lessons - CURRENT SPECIAL Was $65.00 Now $49
- Excel Download Package - This package includes 33 fully accessible Workbook examples that cover topics