Put new rows into sheet when there is a Semicolon in 1 cell

Hi there,

I have been searching all over the internet for my problem.
My worksheet looks like the one in the image, but it has about 2600 records in it.

Schermafbeelding 2012-11-23 om 10.20.45.png

I want to distract all the semicolons into new rows with the same values as they had when they were still in the semicolon cell.

Could anyone please help. Alot of the solutions I found don't fix this.

Thanks in advance

Hi cyclops,

Welcome to the forum.

If a cell has abcd/defgh; pqrst then do you want these two appear in two different cells but in same row .. correct ?

Regards,
DILIPandey

<click on below 'star' if this helps>