I am using Excel 2007 and returning data into a table using xfODBC, which
returns a number of blank cells. If I do an ISBLANK on the blank cells, it
returns FALSE, ISTEXT returns TRUE. I want to assign a new value to the
blank cells, but since Excel is considering it text, the formula would screw
up legitimate values also.

Any ideas?