split data

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

Guest

How do I split text from one cell to multiple cells using a formula?

I have a hex string that I need to convert to binary for each hex digit - the hex string needs to be entered into one cell and then each 4 bit nibble converted to binary. To do this I need to split the cell across multipke cells....... Using a formula!!

Anyone got any ideas?
 
one way:

A1: FEDC
B1: =TEXT(HEX2BIN(MID($A1,COLUMN()-1,1)),"0000")

Copy B1 over to E1 (or as far as required)
 
Back
Top