No, there is no equivalent function. If you know it will only be the 2
leftmost numbers
=Left(A1,2) - Left(A2,2)
would be such an obvious solution that I am sure that is not the case.
--
Regards,
Tom Ogilvy
"davidm" wrote in
message ...
In VBA two cells containing alphanumeric strings like "123abc" can be
subjected to evaluation via the use of VAL. Thus, with "97asd" in A1
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 and
VALUE
Worksheetfunctions failed me in this regard.
=N(A1)-N(A2) -- 0 while VALUE(A1)-VALUE(A2) -- #NAME error.
--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=390579