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:
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:
Price: USD 29.95
(Updated on 2012-09-21)
Related Excel Solutions for Text ManipulationFormula 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 CategoriesBusiness Finance Financial Markets Operations Management Excel Productivity