What about text format in the cells with the formulas, or are you saying
that the formulas don't change if copied down or that they don't change if
you change the contents of the cells involved or that they give an answer
you think is incorrect?

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


wrote in message
oups.com...
I have tried all methods listed on this group (i.e. F9, Ctl+Alt+F9,
ToolsOptionsCalc) and to no avail. The formulas I am trying to use
a

=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