|
|
String manipulation
| Using Excel's string functions
|
Update Link / Bad Link? |
|
Let's pretend that you have an Excel Worksheet that contains a list of employees. They're all entered in the form first name, last name. The problem is that you need to extract the last names only. Let's take a two-day look at the elements needed to do this.
Submitted Sep 30, 1999
Updated Mar 14, 2008
by Raj Rahman
Rating:
(4 Ratings)
Rate this link
Total Visits: 550
|
| 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:
(1 Ratings)
Rate this link
Total 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:
N/A
Rate this link
Total 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:
N/A
Rate this link
Total 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
by Stephen Allen
Updated Mar 08, 2007
by Stephen Allen
Rating:
N/A
Rate this link
Total Visits: 9
|
| 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. |
|
Update a Link
Recent Links 
Newsletter 
My Profile 
Link
To Us