| Excel Text Formulas and Formula Tips |
|
Get the run down on Excels Text functions and some cool tips about working with formulas in Excel.
Submitted:
|
| Formula Manager |
|
This one Excel Add-in makes the management of Excel formulas a breeze. Transpose Formulae, Absolute/Relative toggle, Formula Report and much more.
Submitted: Jun 09, 2003
|
| Custom Formats in Excel |
|
Excel has custom number formats that can be used on dates, times, text and currencies. There are some practical examples and a link to Microsoft’s information on custom number formats that I highly recommend!
Submitted:
|
| GetFormula |
|
To show the formula of another cell, you can use a simple VBA macro. GetFormula was written as my first contact with an Excel newsgroup. Most of the help came from Alan Beban; I managed to simplify it to exactly what I really wanted. It has proven very useful.
Submitted: Sep 30, 1999
|
| Spreadsheet Composer |
|
Spreadsheet Composer is an Excel add-in which provides facilities to automatically construct, verify, catalogue, manage and implement complex worksheet formulae. The core capability of the add-in is the ‘compose’ function which allows a user to define a spreadsheet calculation as a series of linked steps and then automatically ‘compose’ the calculation into a single complex formula.
Submitted: Oct 09, 2003
|
| Select Cells with Formulas or Constants |
|
The following will color font red for all cells with formulas in range, or for entire sheet if only a single cell is selected.
Submitted: Sep 28, 1999
|
| UseFormula |
|
UseFormula is the opposite of GetFormula. UseFormula will do the calculation based on a formula in the referenced cell, which should be entered as a formula after a single quote makeing it a text string.
Submitted: Sep 30, 1999
|
| Extracting Words From Text in Excel |
|
Excel has very powerful and useful Text formula/functions that we can use to extract words from a string of words. Or, put another way, parse out specific words from text. The example below show how we can use the Excel formulas to do this.
Submitted: Jul 04, 2005
|
| GetFormat |
|
Another item that I thought would be interesting to document is the cell formatting string seen below in GetFormat invoking another simple VBA macro.
Submitted: Sep 30, 1999
|
| fuzzyTECH |
|
fuzzyTECH is the basis of many successful applications of fuzzy logic in Japan, Europe and the U.S. This package includes an Excel add-in.
Submitted: Aug 29, 1999
|
| Alternate Row Coloring |
|
Now that Excel has Conditional Formatting (since Excel 97) we can use it to create an alternate row color for a table of data. This is often referred to as color banding and means that every second row should be filled with a specified color.
Submitted: Jul 04, 2005
|
| Count of Each Item in a List |
|
With the aid of Advanced Filter and the COUNTIF we can get a count of each item that appears in a list
Submitted: Jul 04, 2005
|
| Determining the Data Type of a Cell |
|
In some situations you may need to determine the type of data in a cell. Excel provides a number of built-in functions that can help. These include ISTEXT, ISLOGICAL, and ISERROR. In addition, VBA includes functions such as IsEmpty, IsDate, and IsNumeric.
Submitted: Sep 28, 1999
|
| Count Words in a Cell |
|
Unlike Microsoft Word, Excel does not give us a ready made way to find out the number of words in a cell, or a range of cells containing text, or words. These Excel formulas show you how.
Submitted: Jul 04, 2005
|
| Name Field Reconcatenation |
|
Turning names the other way around (surname, forename) automatically.
Submitted: Nov 10, 2003
|
|
