Home > Excel > String manipulation
Top-Rated Links 
Most-Visited Links 

String manipulation

Add-in for Excel Text Update Link / Bad Link? 
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
Rating: 0.00   Rate this linkTotal Visits: 296
Changing Text Case Update Link / Bad Link? 
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
Rating: 0.00   Rate this linkTotal Visits: 130
Phone Number Names Update Link / Bad Link? 
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
Rating: 0.00   Rate this linkTotal Visits: 113
Importing Data from External Sources Update Link / Bad Link? 
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
Rating: 0.00   Rate this linkTotal Visits: 9
  Link To Us

Terms of Use:  
NOTICE: Links you submit to Mathtools.net Link Exchange will be accessible from any part of the world via the web. Any information such links contain may be used by The MathWorks and the public, both within and outside the country from which you posted. Read complete disclaimer prior to use.


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