On Fri, 26 Aug 2005 18:39:02 -0700, Geo wrote:

Thank you for your replay. I found my error but how to correct it.
In cell A1 I have 08 02 13
This has spaces which Excel detects as text.

In cell A2 I have =LEFT(A1,SEARCH(" ",A1,1))
The result is 08, again this is detected as text

In cell A3 I have =hex2bin(UPPER(A2),8) or =hex2bin(A2,8)
Both provide the #NUM error. Untill today I overlooked the fact that A2 was
not a number.

I have tried the Convert text to number as described in Help but I never get
the Convert option.

Again thanks for your help

Your formula will return a trailing space, and that is what is giving the #NUM
error.

Also, I do not believe there is a need for UPPER in the HEX2BIN formula, at
least not in Excel 2002

To convert the first pair of digits, try:

=hex2bin(LEFT(A1,2),8)

or, if your digits may not be paired:

=hex2bin(LEFT(A18,FIND(" ",A1)-1),8)

--ron