In VBA two cells containing alphanumeric strings like "123abc" can b
subjected to evaluation via the use of VAL. Thus, with "97asd" in A
and "54jkm" in A2,
Val(Range("a1"))-Val(Range("a2")) yields 43 ~ (97 minus 23).

Is there a Worksheetfunction that perfoms such role? Both the N an
VALUE
Worksheetfunctions failed me in this regard.

=N(A1)-N(A2) -- 0 while VALUE(A1)-VALUE(A2) -- #NAME error

--
david
-----------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...fo&userid=2064
View this thread: http://www.excelforum.com/showthread.php?threadid=39057