swapping numbers...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've successfully converted binary to hexadecimal (Using only 4 didigts), but now I need to swap the first two digits and last two digits of the answer. Or better yet just eliminate the first 2 digits for one answer, then the last two digits for the other. Obviously if using the last two digits that would be easy by adding a 2 in the formula below instead of a 4. But my problem remains with the 2 MSD's.

=BIN2HEX(C10,4)
 
Assuming result in A1

=LEFT(A1,2)
=RIGHT(A1,2)

Is that all you want?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Peterjl said:
I've successfully converted binary to hexadecimal (Using only 4 didigts),
Click to expand...
but now I need to swap the first two digits and last two digits of the
answer. Or better yet just eliminate the first 2 digits for one answer,
then the last two digits for the other. Obviously if using the last two
digits that would be easy by adding a 2 in the formula below instead of a 4.
But my problem remains with the 2 MSD's.
 
Back
Top