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.

Description of Text Manager:

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.

See Also: All products from OzGrid Business Applications

1. Project Management 1.0
   The Project Planning and Management template is designed as a generic solution to plan and manage any project.
2. Cash Flow Valuation Model for Excel
   The Cash Flow Valuation Model for Excel is the perfect tool for comparative company or project valuations. Cash flow analysis is the basis for most sound investment and business decisions.
3. ExcelPipe Lite
   ExcelPipe is used by IT personnel to repair hyperlinks when a server gets renamed, by SMEs and large organisations when they change their contact details/name/etc, by translators to apply massive search/replace lists - the list of uses is endless.
4. Formula and Text Manager for Excel
   FORMULA MANAGER: 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.
5. Easy Hour Assignments for 25 People with Excel
   The Easy Hours Scheduler saves you scheduling headaches and time by letting you simply specify your daily staffing needs and then assign them to up to 25 people by inserting a number in the start time column.
6. COMxL RS232C
   Link a measuring instrument to YOUR Excel worksheet via RS232 port
7. Quick Charts for Microsoft Excel
   Quick Charts for Excel is a menu driven Excel workbook that allows you to construct a graph of one row of data and then to easily change from one row of data to another using the Quick Charts tool bar.
8. Name Splitter for Microsoft Excel
   quickly and easily split names that are in one cell into individual names in individual cells.
9. Advanced Data Grid Control - Standard License 3.5
   This java Data Grid Control applet enables the display of data in rows and columns in java & web applications. Powerful features include Fast Sorting, Data Acquisition, URL Hyperlinks, Embedded Images, Column Totalling and much more.
10. Ultimate Business Forms
    Ultimate Business Forms is a comprehensive collection of 85 different intelligent Excel templates designed by professionals.
11. OO Picture
    The game topic is to find the 5 different place from two pictures which are seem to be the same. There is 5 chance of rescue yourself. Every chance can help you to find one different place.
12. Added Irregular Payments Amortization +
    This program is an added payment schedule that demonstrates the effect of addding payments at different times to reduce the term of a loan and also reduce the amount of interest paid. It will run underWin9x,winNT4, Win 2000, Me &XP.
13. Trace Remover 1.2
    Trace Remover is a very useful program for cleaning up the history of your activities on a computer. Many people do not realize that Windows and other software programs store information about what they have done.
14. CMEditor
    CustomMenu enhances MS IE significantly. It is an easier, faster and unique way to surf and shop on the Web by just a point-and-click. It can manage URLs and display them as drop-down menu on browser's menu bar.
15. AD Midnight Fire
    Midnight Fire - animated desktop wallpapers is the qualitatively new replacement of the well-known wallpapers, but in a difference with the simple beautiful images we offer you the real living world, full of sounds and of movement, where time goes...
16. Smart Popup Blocker 1.0
    The annoying pop-up ad windows disturb your sights and occupy your system resource. How can you clear them? Ok,If you use the Smart Popup Blocker, the trouble will be gone.
17. 5mEmerg
    5mEmerg (The 5-Minute Emergency Medicine Consult) is a well-structured emergency medical consult for Mobiles,Palm OS, Windows and Pocket PC handheld devices.
18. SolidTrend 6 Month Professional License
    SolidTrend is an advanced real-time and end-of-day technical analysis charting system for financial markets.
19. Agent Sokoban 1.00
    Byxon Games Inc. released a new game Agent Sokoban. The game features: 375 original creative puzzles. Great 3D graphics Agent Sokoban runs fast even on weak computers.
20. Formula and Text Manager for Excel
    FORMULA MANAGER: 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.