Home/ Questions/Q 11907
Next
Answered
computing
  • 20
Asked: 2021-12-08T12:17:50+00:00 In:

Solved How To Extract/Retrieve Email Addresses From An Excel Sheet?

  • 20

this is how I have all my data. there are more than 200 contact info. Everything is in column A and I’m trying to retrieve only the email addresses and paste them in another column. How can I separate the email address????

COMPANY NAME
ADDRESS
Phone:
Fax:
Email: test@test.com
Web: www.test.com

I have excell 2010

Share

    1 Answer

    1. Best Answer
      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:

      =IF(ISERROR(FIND(“@”,A1)),””,A1)

      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.

      • 0