hi.
i tested before posting. in 2003, my formula returned numbers when numbers
and blanks when letters.
your formula works also.

regards
FSt1

"David Biddulph" wrote:

If you try it I think you'll find that will always return a blank, as the
MID formula in B retuns text, not a number.

Try =IF(ISNUMBER(--B1),--B1,"")
--
David Biddulph

"FSt1" wrote in message
...
hi
=if(ISNUMBER(B1),B1*1,"")

regards
FSt1

" wrote:

Here's what I got:
A1=1007543
A2=10C49
B1=formula:mid(A1,3,2) [which displays 07]
B2=formula:mid(A1,3,2) [which displays C4]
C1=formula: B1*1 [which displays 7]
C2=formula: B2*1 [which displays #VALUE]

I'm trying to write a function for C that will display [blank] where
there is a 'character' in B and a [number] where there is a 'number'
in B.

I've tried:
isnumber - they aren't numbers
value - still get #value for C2

Any other ideas?

-Bruce