Tuesday, September 27, 2011

spreadsheet formula for getting domains from email addresses

In case you're using Excel, Google Spreadsheets, or another spreadsheet program and you have a list of email addresses that you'd like to use to get a list of domains, you can use the formula:

=RIGHT(A1, (LEN(A1)-(FIND("@", A1))))

What this gives you is the characters from the RIGHT of the text in cell A1 up to the @ sign. FIND tells the equation where the @ symbol is from the left, which is then subtracted from the LENgth of the text in cell A1.

No comments: