Example of data:

H: (111) 222-3333 W: (111) 222-3333 Cel: (111) 222-3333 W Fax: (111)
222-3333 Email:
-----------------------------------------------------------------------------------
H: (444) 555-6666 W: (444) 555-6666 Email: W Fax: (444)
555-6666

Example = 1 column and 2 rows of data and I am trying to extract the email
address and place it into a single column without cut and paste 5000 times.

The text to columns feature works but spread the addresses haphazardly
across 20+ columns. That leads to a new question, I want the email in column
A and they are spread out B-Z. How do I get them all in column A without C&P.
I tried "=B1-Z1" in A1 and got "#VALUE".