Extracting cells in a row.

[tonym]

Hi, I have a large email list of companies in various countries, and I need to extract by country. For example I need to extract all email addresses that end in ".IT" (Italy) or all email addresses that end in ".ES" (Spain)

How can I do this please.

Regards,

Tony.

 

[Michael M]

Hi and welcome to the Board
You could use a helper column to find the country and then sort by that column
Assuming the E mail addresses are in column "A"
Put in a vacant column

=Right(A1,2)

and copy down
Now sort by that column OR custom filter that column for "IT" or "ES"

 

[tonym]

Hi Michael, thanks for your prompt reply. I tried what you suggested and it did not work !

I am very new to Excel so I am sure I am doing something wrong.

Could you explain in more basic terms how to do it.

Thanks,

Tony.

 

[wigi]

Hello there

You can use an Autofilter (it is found in the menu under Data). Then, choose the option to filter the values on "Ends with..." and fill in IT for example. All rows that match will then be shown, the others will be hidden from sight.

Wigi

 

[pgc01]

Hi Tony

You can also extract it directly using the Advanced Filter with the option "Copy to another location".