|It gets a bit difficult to extract text when we don't have a consistant starting point. Excel was never built to be a text editor.|
Anyway, if the only two situations you have are the two you've described, and they are exactly as you have described, try this:
Put this in B1 and drag it down:
Select Column B and do a Copy...PasteSpecial...Values to eliminate the formulas and leave the text.
With Column B still selected, do an Edit...Replace...
Find what: "Email: " (no quotes, but include the trailing space)
Replace with: leave this field empty
Sort Descending to bring all of the email addresses to the top of Column B.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.