Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Nermina
Nermina asked in Computers & InternetSoftware · 1 decade ago

how to remove the domain names from a list of emails?

i have an excel sheet with list of emails i want to encrypt the emails by removing the domain names after the ( @ )

is there a way to remove the ( @domain.com ) from the list of emails one time

2 Answers

Relevance
  • Denn
    Lv 5
    1 decade ago
    Favorite Answer

    Assume email addresses are in column A starting at A1 and you want the stripped address in col B.

    In Cell B1 insert formula

    =LEFT(A1,FIND("@",A1)-1)

    Then drag this formula down for all of Column B (or copy paste it )

    HTH

  • Ken
    Lv 4
    1 decade ago

    Use the Excel text-to-columns feature and split the emails into 2 columns using the @ delimiter.

    Then delete or hide the domain column.

    Source(s): Excel help
Still have questions? Get your answers by asking now.