Change case in Excel, Join text to one cell, Remove spaces, etc.

Text Manager in detail

Text Manager for Excel

The Text Manager for Excel will make working with text in your Excel 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 worksheet.

Text Manager: Change Case in Excel

The Change Case lets you instantly change the case of your text. You can nominate to change your text to:

• UPPER CASE
• lower case
• Proper Case

Text Manager for Excel: Remove Characters or Text

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 in Excel (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
• All spaces, except for single spaces between words.

Text Manager for Excel: Join Text to One Cell

Have some text you wish to concatenate (join, link together)? The Text Manager can do this 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 Text Manager to add a space between each cell that is joined.

See also in "Excel - Data management - merge, convert, delete"

• Address Assistant - Split addresses from one cell into multiple cells.
• Consolidation Assistant - Consolidate data from Excel workbooks or worksheets.
• CSV File Creator - Create a CSV file from Excel workbooks / worksheets.
• Data Assistant for Excel - Make table form data applicable for Excel pivot tables.
• Data Cleaner for Excel - Remove spaces, Change text case, Replace / modify text, etc.
• Data Extraction Assistant for Excel - Extract data from one worksheet to many spreadsheets.
• Data Loader for Excel - Easy loading, processing, and transferring data .
• Filter Assistant - Filter multiple Excel spreadsheet columns at a time.
• Formula Manager - Manage all formulas in Excel worksheets easily.
• Formula Ref Changer and Sheet Index Creator - Change Excel formula reference types.
• List Assistant - Easy way to re-arrange rows in your Excel worksheet.
• Name Splitter - Split names into several Excel cells.
• Number Manager - Fill in the gaps in Excel workbooks.
• Report To Data Assistant - Convert text reports into Excel worksheet databases.
• Spreadsheet Assistant - Over 200 useful features for MS Excel.
• Text File Importer - Import text files with over a million lines into Excel.