Home > Excel > String manipulation

String manipulation

Add-in for Excel Text  
The Text Manager will make working with text in your spreadsheet very easy. It is particularly useful for text which has been imported into Excel. Do in minutes what would take hours.
Submitted: Dec 10, 2003
Changing Text Case  
Excel does not have a formatting code to display text in upper case. Therefore, if you want your data to display in all upper case (or lower or proper case), you have to change it yourself or force the data entry itself to be upper case. This may be important to your application (for example, if your data consists of two character state abbreviations), and can be easily accomplished with some simple and straight-forward VBA code.
Submitted: Sep 07, 1999
Phone Number Names  
Phone Number Names is a nifty tool that displays up to 59,049 possible words you can make with the letter combinations of any ten-digit phone number.
Submitted: Sep 11, 1999
Importing Data from External Sources  
Importing data from external sources can create a range of problems for the excel users. By external sources I mean Word documents, PDF files and html files. (In general, Excel already deals with fixed field and delimited fieled text files very well). Mostly the problems derive from the reordering of data, the addition of unexpected space characters and the import of unexpected formatting codes. The ACBA "ConCatStr.xla" addin (short for concatenate and post a string) provides 5 small functions for gathering together and re-posting data in the right order, for returning selected ranges to a standard default format and for removing either multiple space characters or all space characters depending on your requirements.
Submitted: Feb 17, 2007

  Privacy - Trademarks - Feedback - Terms of Use Copyright The MathWorks, Inc.