extract info from cell, then count

  • Thread starter Thread starter cathal
  • Start date Start date
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. (e-mail address removed), 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.....
 
One way:


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

A pivot table would be an easy way to summarize.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting from multiple fields 7
Counting NONZERO Cells - Filtered and Pivoted 6
Counting Blank Cells in Pivot Table 1
Count text then add results 2
Extracting part of a cell 6
Subtotal - SUM, COUNT NUMBER, 'Live' Formula 5
do i use countif? 2
Counting cells with same info in them 1

Back
Top