I am trying to use =HEX2BIN(A2,8)

If cell A2 has data this will work

If cell A2 has a formula it will not work

Does anyone know of a workaround?

Thanks

It works fine on a cell with a formula as long as a valid result is
returned.

You might want to upshift text to help it though

=hex2bin(UPPER(D6),8)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Geo" wrote in message
...
I am trying to use =HEX2BIN(A2,8)

If cell A2 has data this will work

If cell A2 has a formula it will not work

Does anyone know of a workaround?

Thanks

Hi Bob,

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


"Bob Phillips" wrote:

It works fine on a cell with a formula as long as a valid result is
returned.

You might want to upshift text to help it though

=hex2bin(UPPER(D6),8)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Geo" wrote in message
...
I am trying to use =HEX2BIN(A2,8)

If cell A2 has data this will work

If cell A2 has a formula it will not work

Does anyone know of a workaround?

Thanks

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