ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   I need help with Excel (https://www.excelbanter.com/excel-worksheet-functions/81692-i-need-help-excel.html)

Riaan Welman

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

Don Guillett

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




Bernard Liengme

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