I am trying to find a formula that convert Hex to Binary. I have already found one but now I am required to use a divide and conquer approach for the first and second digit.
example:
Input Hex B7 B= 1st digit 7= 2nd digit
Binary 10110111
someone suggest me to consider Right and Left functions to extract the digits from the input and “&” for concatenating strings… any formula suggestions?

Thanks