split data

G

George

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?
 
J

J.E. McGimpsey

one way:

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top