I need help with Excel

R

Riaan Welman

I am trying to extract only email address out of a collumn with different
kinds of information. The collumn has 22000 rows of information, of which
about 4000 is email addresses. How can I tell Excel to go and get these
addresses and paste them somewhere else
 
D

Don Guillett

Several ways
1. a findnext (look in vba help) to search for @ and copy/move to another
location
2. a helper column using find formula function to extract @>sort (or
autofilter) >copy
 
B

Bernard Liengme

Assuming list in column A
In B1 enter =--(SUBSTITUTE(A1,"@","!")=A1)
Sort A:B using B as primary sort
Copy and Paste
best wishes
 
Top