Use excel to do something with email addresses

OU812

I have a spreadsheet with several hundred people on it. One of the fields is their email addresses all in one column. I want to be able to find out how many people use Hotmail/gmail/other/corporate addresses & find that out as a percentage

e.g. 100 users, 27 use hotmail, 36 use gmail, 13 use corporate email, 24 use other email (.edu etc)

Is there a formula that will examine the email column & look at everything after the "@" symbol & give me this info in another sheet ?

MissFlitworth

Once you know all the email domains you want to count you could do this using countif

so, for hotmail =countif([range], "*@hotmail.com") will count every entry in a range with @hotmail.com in it, regardless of what's before the @. =countif([range], "*@gmail.com") will do the same for Gmail addresses etc.

Gordon

You could always save the excel file as text, then import only the email column into a new excel file and use the @ symbol as a delimiter. This will give you two columns, the email name and the provider. For which you could then sort/count etc.

PrzemoF

Hints:
=search()
=right()
=len()

=RIGHT(A1,LEN(A1)-SEARCH("@",A1))
when A1 contains an email. then count the results

OU812

PrzemoF wrote: »

Hints:
=search()
=right()
=len()

=RIGHT(A1,LEN(A1)-SEARCH("@",A1))
when A1 contains an email. then count the results

This worked fast !

beanie10

Could you use the "find" option. It's on the top right.