Hi,
I have a column with multilines cells that I'd like to split in the next columns. Each line in the cell is a couple (name, value):
Cell A1:
Titi&20
Toto&3
Tata&321
I've added columns for B1=Titi , C1=Toto and D1=Tata and I'd like to have a macro that fill columns B, C, D with values in the multi-lines A column:
B2=20 C2=3 D2=321
Would you know how to do it ?
Many thanks,
Alain