Home > Excel Business Solutions > Excel Productivity > Time Saving > Text Manipulation Share

Text Manipulation

Excel text manipulation for time saving


Excel Text Manipulation

Rate this solution:
(3/5 from 1 vote)
The Text Manipulation Add-in for Excel simplifies the working with text within Excel spreadsheets. It is particularly useful for text which has been imported into Excel. Either a range of cells or the entire sheet can be specified to undertake text manipulation tasks.

The Change Case feature allows to instantly change the case of the text. Text can be automatically changed to upper case, lower case or proper case.

The Remove Character or Text feature can save many hours of manually removing specific characters, or text strings, from specified text. Characters to remove can be directly copied from the Windows Character Map. If the character or text to remove is not available, the 'Specify Character or Text' option can be enabled.

Several common problems can arise when importing text into Excel. These include numbers not being recognized as numeric values; date values not being recognized; and difficulty in breaking up text, referencing text or using text in formulas. To overcome these issues the Text Manipulation Add-in for Excel can remove all:
  • Leading spaces
  • Trailing spaces
  • Trailing and Leading spaces
  • All spaces, except for single spaces between words

The Text Manipulation Add-in for Excel can also concatenate (link together) text quickly and easily by specifying the cells to concatenate and the cell to concatenate the text into. The text is then instantly be joined. An option also exists to add a space between each cell that is joined.

The Text Manipulation Add-in for Excel is also available in the following discounted bundled offers:

Get It

Price: USD 29.95
(Updated on 2012-09-21)

Related Excel Solutions for Text Manipulation

Formula ManagementTime Saving  Productivity Add-insTime Saving  Table ManagementData Management  Number ManagementTime Saving  Name ManagementTime Saving  Text ManagementData Management  Remove Cell TextData Management  Unstructured Data ImportData Management

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum or proposed as a project to the Excel freelance community.