I have a lot of data in one cell in excel...and the data looks like this...

; ;

I want to copy the text between each semilcolon...then past it to a new cell..

how do i loop through the cell and copy the data between each semicolon?

Thank you