Add-ins and other tools
ConnectCode Text Manager Add-in for for Microsoft® Excel®
ConnectCode Text Manager is a productivity Add-in for working with text in Microsoft Excel. It allows you to easily make text modifications to your existing cells, range or entire worksheet. Changing a range of cells to different case, removing specific special characters(or multiple characters) and trimming the cells can all be carried out very effectively and easily. This Add-in also allows you to concatenate several cells together and add spaces for the text of the cells. This is a must have Add-in if your daily tasks involve working with text in Excel. It will definitely save you many hours of tedious work.
Download Free Trial - Features - Purchase
Price $29.90 (Single User License)
Features
Apply To
- Range - Click on Range and then do a select of cells in Excel. All the selected cells will applied with the Text operations mentioned below when the Apply button is being clicked on. The unregistered version comes with a maximum 10 cells restriction.
- Entire active sheet - Select this option for the Text operations to be carried out on the entire worksheet.
Change Case
- UPPER CASE - Change all the text in the selected cells to upper case.
- lower case - - Change all the text in the selected cells to lower case.
- Proper Case - - Change all the text in the selected cells to proper case. This means the first character of every word will be in upper case while the rest of the characters of the same word will be in lower case.
Remove Characters or Text
This option allows you to quickly and easily remove unwanted characters or text from your specified range.
- Choose Character(s) - Select one or more characters from this box and click "Apply" to remove the unwanted characters.
- Specify Character or Text - If you select this option, a dialog will pop up and ask you for the specific character to remove when you click the Apply button. If you need to remove a special character, you can open up the "Character Map" and copy a character from it, and paste it (using CTRL-V) into the popup dialog when it appears after you click "Apply".
- Match Case - Match the case in the cell exactly before removing the characters.
- Whole Cells - Remove the specified text or characters if they occupy the entire cell.
Trimming
- Left Trim- Remove all the leading spaces. For example, " The quick fox. " becomes "The quick fox. ".
- Right Trim - Remove all the trailing spaces. For example, " The quick fox. " becomes " The quick fox.".
- Left & Right Trim - Remove all the leading & trailing spaces. For example, " The quick fox. " becomes "The quick fox.".
- All Trim - Remove all the leading, trailing & excess spaces. For example, " The quick fox. " becomes "The quick fox.".
Concatenate (Join) Text
This option allows you to quickly and easily concatenate text from different cells and add a space between the text. The unregistered version comes with a maximum 2 cells restriction.
Download
Download a free trial of the ConnectCode Text Manager Add-In
System Requirements
- Microsoft Windows 2000 ,Win XP and 2003, Vista
- 300 MHz processor
- 64 MB RAM
- 5 MB of Hard Disk space
- Excel 200 or Excel 2003 or Excel 2007
TextManager.exe (EXE Format)
TextManager.zip (Zip Format)
|