![]() |
I need help with Excel
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 |
I need help with Excel
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 -- Don Guillett SalesAid Software "Riaan Welman" <Riaan wrote in message ... 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 |
I need help with Excel
Assuming list in column A
In B1 enter =--(SUBSTITUTE(A1,"@","!")=A1) Sort A:B using B as primary sort Copy and Paste best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Don Guillett" wrote in message ... 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 -- Don Guillett SalesAid Software "Riaan Welman" <Riaan wrote in message ... 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 |
All times are GMT +1. The time now is 10:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com