Excel2007 Multiple Data Separation in single cell

[hactic]

Hi, I would like to do the following:


FROM 101-1011-1-78-0 111-1111-1-78-0, 105-1051-2-78-0

TO 101-1011-1-78-0 111-1111-1-78-0
101-1011-1-78-0 105-1051-2-78-0
111-1111-1-78-0 101-1011-1-78-0
105-1051-2-78-0 101-1011-1-78-0

Please see excel file for clarity. And thanks very much for any help.

[tigertiger]

Hi, I would like to do the following:

Please see excel file for clarity. And thanks very much for any help.

I try to guess your idea (through yr attached file), plz enter the formulas

for B3:B6 (respectively)
=+B1
=+B1
=+C3
=+C4

for C3:C6 (respectively)
=+LEFT(C1,FIND(",",C1)-1)
=RIGHT(C1,LEN(C1)-FIND(",",C1)-1)
=+B3
=+B4

[hactic]

I try to guess your idea (through yr attached file), plz enter the formulas

for B3:B6 (respectively)
=+B1
=+B1
=+C3
=+C4

for C3:C6 (respectively)
=+LEFT(C1,FIND(",",C1)-1)
=RIGHT(C1,LEN(C1)-FIND(",",C1)-1)
=+B3
=+B4

ok thanks, I'll try and let you know.