Donate SIGN UP

Working With Excel

Avatar Image
Barquentine | 08:50 Thu 15th Jan 2015 | Computers
4 Answers
I have a database of addresses and emails in an Excel spreadsheet. I need to filter it so that all the emails are grouped together. I could go down copying and pasting each email but there are several hundred! Is there a way to get Excel to do it for me?
Gravatar

Answers

1 to 4 of 4rss feed

Best Answer

No best answer has yet been selected by Barquentine. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Question Author
Not to worry - I've sorted it (so to speak)! I noticed all the email addresses are in blue and you can sort by colour!!
Select/highlight all, then you can just tell it to sort the data alphanumerically on the column that holds the e-mail addresses.
As O_G says - I have a data tab on Excel spreadsheets, click that then take the Sort option, you can tell it to sort by whichever column you want.
As the others have said, sort by column but be sure to select the whole document before you sort. otherwise you will only have the emails in order and they will not take the rest of the data with them or relate to the names and addresses

1 to 4 of 4rss feed

Do you know the answer?

Working With Excel

Answer Question >>