Hi Lyndon,

From the Release Note:

• The FIND function now returns zero rather error if nothing is found.

A side effect of this change is that characters in the searched string are counted from 1 rather than zero. Thus the formula to isolate the department in Column C goes from:

Code:
=TRIM(MID($B12,FIND("-",$B12,1)+2,LENGTH($B12)))


To

Code:
=TRIM(MID($B12,FIND("-",$B12,1)+1,LENGTH($B12)))


This change was necessary to make the operation of FIND() be consistent between GridView and the Financial Reporter. We’ll update the Release Note.
_________________________
Andrew Bates