"I realize this is confusing" is not a good way to end a message. And you
are right. I have absolutely no idea what you are talking about.

You talk about code, but don't provide it. You talk about hex and binary
but never give examples of what you mean.

You have shown strings and then talk about binary  value or bit  value.
Strings in Excel will be held in whatever form  Excel chooses, and talking
about binary value or bit values for them seems meaningless.

Please re-post. (1) use a meaningful subject; (2) explain what you want to
do (not how you want to do it); (3) give properly explained examples.