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.

 Download now     Click to buy from RegNow

User Opinions: 0 votes

Submit your opinions

1. Complete Excel Course (Business & Finance > Spreadsheets)
2. Excel and Excel VBA Tips and Tricks (Business & Finance > Spreadsheets)
3. Excel Download Package (Business & Finance > Spreadsheets)
4. Excel Duplication Manager Add-in (Business & Finance > Spreadsheets)
5. Excel Level 1, 2 and 3 Training (Business & Finance > Spreadsheets)
6. Excel Level 1 Lessons (Business & Finance > Spreadsheets)
7. Excel Level 2 Lessons (Business & Finance > Spreadsheets)
8. Excel Level 3 and Excel VBA Courses (Business & Finance > Spreadsheets)
9. Excel Level 3 & Excel VBA & Excel UserForm Courses (Business & Finance > Spreadsheets)
10. Excel Level 3 Lessons (Business & Finance > Spreadsheets)
11. Excel Levels 1 and 2 Training (Business & Finance > Spreadsheets)
12. Excel OzGid Plus With Duplication Manager (Business & Finance > Spreadsheets)
13. Excel VBA Level 1 and Excel UserForms (Business & Finance > Spreadsheets)
14. Excel VBA Level 1 Lessons (Business & Finance > Spreadsheets)
15. Excel VBA UserForm Lessons (Business & Finance > Spreadsheets)
16. Formula and Text Manager for Excel (Business & Finance > Spreadsheets)
17. Formula Manager (Business & Finance > Spreadsheets)
18. Formula Ref Changer and Sheet Index Creator (Business & Finance > Spreadsheets)
19. Number Manager (Business & Finance > Spreadsheets)
20. Number,Text & Formula Manager (Business & Finance > Spreadsheets)
21. OzGrid excel Addins Collection (Business & Finance > Spreadsheets)
22. OzGrid Excel Plus Add-in (Business & Finance > Spreadsheets)
23. Text Manager (Business & Finance > Spreadsheets)
24. Time Sheet Advanced (Business & Finance > Spreadsheets)
25. TimeAndWageBook (Business & Finance > Spreadsheets)