Formulas Not Working in Excel 2003

Giganews Newsgroups
Subject: Formulas Not Working in Excel 2003
Posted by:  jeffreybelch…@gmail.com
Date: 3 May 2006

I have tried all methods listed on this group (i.e. F9, Ctl+Alt+F9,
Tools>Options>Calc) and to no avail. The formulas I am trying to use
are:

=EXACT(B2,B3)

and

=RIGHT(B2,2)

Obviously the first is to check for duplicates, and the second I am
trying to extract the state from a cell that contains "City, State".
Any help would be greatly appreciated!

Jeff

Replies