I have a piece of HTML (listbox content) which looks like this:

"<select id="distributionListForm_mailMember
name="distributionListForm_mailMember" class="lg_field" size="5
multiple="multiple"<optio
"emailaddres1@doman. com</option<optio
"emailaddres1@doman. com</option<optio
"emailaddres1@doman. com</option"


I want to paste this into a cell (A1), and have a bit of VBA tha
tidies the string up, leaving just the email addresses.

Any pointers

--
Zoorop
-----------------------------------------------------------------------
Zooropa's Profile: http://www.excelforum.com/member.php...fo&userid=3679
View this thread: http://www.excelforum.com/showthread.php?threadid=56504