:: Subscribe to our newsletter
 
Articles / Directory
02/10/2012
Latest version of TraderCode(v5.5) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.



1/04/2011
InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.



9/01/2009
Launch of
Free Investment and Financial Calculator for Excel.



1/02/2009
Launch of NeuralCode(v1.0) for
Neural Networks Trading.



8/06/2008
Launch of ConnectCode Excel Training Courses. Get this
Free Excel Training (over 100 pages) now.



7/23/2008
ConnectCode Text Manager - add-in that enhances your productivity when working with text in Excel.



6/17/2008
ConnectCode Number Manager - add-in that enhances your productivity when working with numbers in Excel.



6/3/2008
ConnectCode Barcode Font Pack - enables barcodes in office applications and includes an add-in for Excel that supports mass generation of barcodes.



2/1/2008
Release of
SparkCode Professional - add-in for creating Dashboards in Excel with sparklines



12/15/2007
Announcing
ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel



09/08/2007
Launch of
TinyGraphs - add in for creating sparklines and tiny charts in Excel.

Add-ins and other tools


ConnectCode Text Manager
Add-in for Microsoft® Excel®

Microsoft Office Marketplace logo

ConnectCode Text Manager is a productivity Add-in for working with text in Microsoft® Excel®. It allows you to easily make modifications to the text of existing cells, range or entire worksheet. Changing the text from a range of cells to a 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)


Compatible with Excel 2003 through 2010




Features

Apply To

  • Range - Click on Range and then do a select of cells in Excel using the mouse. All the selected cells will apply the Text Operations described below when you click the Apply button. The unregistered version comes with a maximum 10 cells restriction.
  • Entire active sheet - Select this option to apply the Text Operations 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 when you click on the Apply button. You may specify the characters you want to remove within the dialog.
  • 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 ,Microsoft® Windows XP® and 2003, Microsoft® Windows 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)



Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.


 

Copyright (c) 2007-2015, ConnectCode Pte Ltd. All Rights Reserved.


Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. All other product names are trademarks, registered trademarks, or service marks of their respective owners