dstiefe,

- Select the cells that have data like this. Columns to the right should be
blank. Each email address will be placed in cells to the right of the ones
selected.
- "Data" menu "Text to Columns..." submenu
- Make sure "Delimited" is selected
- Click the "Next " button
- Check "Semicolon"
- Consider unchecking all other delimiters...especially if any of them show
up in the data.
- Click the "Finish" button to execute immediately...
....or...
- Click the "Next " button just to see what settings are on the next page
- Do not make any changes on Step 3
- Click the "Finish" button.

HTH,

Conan Kelly





"dstiefe" wrote in message
...


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