When I copy your text directly from this post to cell A3 in a blank worksheet
and then copy my formula to any other cell, I get the number result 6. Can you
reproduce that result?


Steve wrote:
This in the cell
Analysis Period: 01/23/2010 to 01/29/2010 - Processing Days: 6
the subtraction would work, as that's really all I need, the days, but this
=MID(A3,FIND(" to ",A3)+4,10)-MID(A3,FIND(" to ",A3)-10,10)
still produced a #value!
Also =isnumber(e19) produced a TRUE


Thanks for your patience.