I have list of email addresses but want to filter just those ending with .uk. Any ideas?
Thanks for the help Mal
I am no excel guru and most of the stuff I do is hacky but you could try copying the email column to a new column. Now click on the column to highlight all cells, click the Data tab and choose "Text to Columns" on the ribbon. Choose Delimited and click next, put a tick in "other" and put the @ symbol in, clik Next, click Finish.
This will then give you a new column with the bit after the @, again click on the top of the column to select all the domain name and extensions and click "Text to Columns" again. Delimited should be checked so click Next, now replace the @ with a full stop, click Next click Finish.
Now you will have two new columns, one with the initial part of any double part domain extentions and one with the second. All official UK extensions are double spaced names, .co.uk, .org.uk, .me.uk, .gov.uk etc. You may have the odd .uk.com but they aren't real UK extensions administered by Nominet so depending on what you are doing you might want a second sort to select those or you might not...
Now that you have all the uk extension parts in one column you can sort on that column and just select the UK ones...
Worked for me on a small dataset.
I am sure some smart arse will come along with some code to do it in a sec but that might be enough to get you through for now...