extract info from cell, then count

C

cathal

I have a 2-part question:

(i) I have 1000's of e-mail addresses but want to extract the countr
from the e-mail i.e. [email protected], where de (Germany) is needed. How d
I isolate the ".de" (and others eg .fr, .edu, .com etc etc)

(ii) Having done the above, I then need to do a count. Rather than us
COUNTIF and include the code for every country in the world, is ther
any other way of counting? I guess a Pivot table?

thanks, cathal.....
 
J

J.E. McGimpsey

One way:


=MID(A1,FIND("^",SUBSTITUTE(A1,".","^",LEN(A1)-LEN(SUBSTITUTE(A1,".",
""))))+1,255)

A pivot table would be an easy way to summarize.
 
Top