Here's a non-macro solution. Copy/paste this formula into the next
column and change A6 to whatever cell is to the left

=MID(A6,FIND("SMTP",A6)+5,FIND(".com",A6)-FIND("SMTP",A6)-1)


---
Message posted from http://www.ExcelForum.com/