Dear,

If somebody can help me out;

I've got a spreadsheet with in some cases in column A combined values (always separated with ";" )and in some of them only one.

CEll A1= AA12883;BB435;AA3621
CELL A2= AA465
CEll A3= AA62003;BB835

ps. The length could be several characters.
The challange is that all rows should have only one value in it. Then it results in

CEll A1= AA12883
CEll A2= BB435
CEll A3= AA3621

CELL A4= AA465

CEll A5= AA62003
CEll A6= BB835

There's the need for a loop from cell A1 till last used column A.
If the cell contains 2 times ";" then copy the whole row twice below the active row. Now you got 3 indentical rows. Then delete in all the rows the part that shouldn't be there

Perhaps there is a better way to solve then I describe above :).


So please :)
(thanks!!)

regards, Johan