Home > Excel > Formula and Format Manipulation

Formula and Format Manipulation

Excel Text Formulas and Formula Tips  
Get the run down on Excels Text functions and some cool tips about working with formulas in Excel.
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!
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 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
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 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

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