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 Addin 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 addin which provides facilities to automatically construct, verify, catalogue, manage and implement complex worksheet formulae. The core capability of the addin 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 addin. 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 builtin 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

