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. OM-ANALYSIS OF WAITING LINES
   Excel Spreadsheet Templates for queue analysis.
2. Number,Text & Formula Manager
   Number,Text & Formula Manager is 3 seperate Excel Add-ins bundled together to save you 50% off the individual prices. Read about these 3 add-ins in details and see screen shots on this site.
3. Excel Levels 1 and 2 Training
   Excel Levels 1 and 2 Courses
4. Visual Basic Macro Examples for Microsoft Excel
   Get over 1200 Microsoft Excel Visual Basic macro examples and solutions in a downloadable help file. Access directly from Excel.
5. ExcelSuite
   ExcelSuite is an application that can process data across numerous Excel workbooks. 1.Add up the same cell across worksheets Is there a way to add the same cell (ie.
6. FES EA Inventory Manager
   FES EA Inventory Manager - inventory manager for Excel with multi-level BOMs support. You can easily customizy this manager for your needs.
7. Name Splitter for Microsoft Excel
   quickly and easily split names that are in one cell into individual names in individual cells.
8. EE Import Contacts
   EE Import Contacts is a Microsoft Excel add-in that allows users to import Outlook contact folders directly into Excel. From userforms, users can determine which fields are imported, and also can edit the Outlook contacts prior to import.
9. Xcelential Standard Edition
   Xcelential lets you view the key charts and data from the latest versions of all your Excel spreadsheet files on a dashboard you can easily build in 5 minutes. Xcelential automatically gets updated spreadsheets from emails and shared folders for you.
10. Spreadsheet Assistant for Microsoft Excel
    Save time in Microsoft Excel with the Spreadsheet Assistant.
11. WinWAX Express 1.5
    WinWAX Express gives you an extraordinary experience to save any web page as single-file .MHT web archive which could be viewed later without an Internet connection. It's very easy to use, and very efficient and effective.
12. 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.
13. Ebay Fraud Detector
    Ebay Fraud Detector is the only Ebay Fraud Pattern Recognition Software on the Internet.
14. Declan's Chinese Dictionary
    Declan's Chinese Dictionary uses the 20,000 word CEDICT Chinese-English dictionary database. Both the GB (Simplified) and Big5 (Traditional) versions of the databases can be used.
15. Online Recorder 5.6
    This spy software lets you monitor web sites visited, emails, chat, instant messages, and more. With a built in keylogger, you can also secretly record keystrokes.
16. Project Engine Server
    Project Engine drives the workflow of an entire project. It is a reliable, scalable and secure solution for projects ranging from a single user to a large corporation.
17. The Muscle and Might Training Tracker
    This 136-page workbook contains everything you need to track your progress, day by day, month by month, year by year. One training log will track your bodybuilding and strength-training progress for at least 24 months.
18. BRAWN
    Revised 2nd Edition! The predecessor to BEYOND BRAWN. BRAWN focuses on genetic realities, appropriate role models, and most of the ins and outs of successful drug-free training.
19. FURTHER BRAWN
    Through our other books weve tried to provide all the information needed to achieve lifelong bodybuilding and strength-training success. But over time we found there were questions that had slipped through unanswered.
20. The Insider's Tell-All Handbook on Weight-Training
    Revised 2nd Edition! How to use perfect exercise form is covered in extensive and illustrated detail. This book contains 244 photographs and over 200 fully indexed big pages showing the right and wrong ways to perform all the most productive exercises.