BACK TO PCSTATS Follow PCSTATS on Facebook PCSTATS RSS Feed PCSTATS Twitter Feed + Motherboards
+ Videocards
+ Memory
+ Beginners Guides
News & Advanced Search  Feedback?
[X]   Directory of
Guides & Reviews
The PCstats Forums

Beginners Guides
Weekly Newsletter
Archived Newsletters

Beginners Guides: Hard Drive Data Recovery

PCSTATS TechTip... Sort an Excel spreadsheet by email domain? - PCSTATS TechTip... Sort an Excel spreadsheet by email domain?
Wed, Aug 24 2011 | 4:15PM | Filed under: Tips| PermaLink Posted by: STAFF

PCSTATS TechTip... Sort an Excel spreadsheet by email domain?

Q: I need to update my websites' news mailing list and remove duplicates, how do I sort the email list in Microsoft Excel by the domain names only? By default Excel sorts everything in front of the @ symbol alphabetically, I need to sort alphabetically everything following the @ sign. Help!

A: By using Data > Sort in Excel it is possible to do this, but first we'll need to pre-format the email mailing list somewhat.
First off, assuming all your email address are listed in Column A (one email address per row), create a second Column in the Excel document so we can use a formula to output only the data following the @ sign in Column A;
=MID(A1, FIND("@",A1, 1)+1, 255)
Paste the above formula into the first cell of Column B, as you'll see, this formula outputs only the domain part of the email address. Click on that cell and hover the mouse over the bottom right-hand corner of the box until you see the cursor turn into a "+" sign. Now click and drag the checkered box down to the very last row of data to copy the formula across all rows.

Next, select all your data by highlighting Column A and Column B in the margins, then go to Data > Sort > and under 'column' choose 'column B' and press 'okay'. This will tell Excel to sort all the data, alphabetically by the domain names in Column B, from there you can easily find and remove the duplicates.


Recent News in Tips
Office 2013 Crashes on Start Up - Solved - PCSTATS TechTip Feb 26
PCSTATS TechTip: Excel Cannot Complete this Task with Available Resources - SOLVED Oct 27
PCSTATS TechTip - Automatically Shut Down Windows at a Certain Time Jan 27
PCSTATS TechTip - More to Calculator than you think Jan 13
PCSTATS TechTip - Fix Excel Being Extremely Slow to Opening Network Files Jan 6
AMD fans rejoice Oct 10
TIP - Windows 8 and Bringing back the Start Menu May 2
TechTip - Bring Back the Quick Launch Bar in Windows 7 May 2
Windows 8: How to Bypass Metro and Boot Directly to the Desktop Interface Oct 31
HotHardware's 2012 Back To School Shopping Guide Aug 28

News Categories
Audio / Sound Beginners Guides Benchmarks
Biometrics BIOS Business / Industry
Cases Chipset Computer / SFF PCs
Cooling / Heatsinks CPU / Processors Digital Cameras
Drivers Editorial Games
Gossip Hard Drives/SSD Hardware
Home Theatre Imaging Memory
Mobile Devices Monitors Motherboards
Mouse Pads MP3 Players Networking
Notebooks Operating System Optical Drives
Overclocking Peripherals Power Supply
Press Release Printers Servers
Site News Software Tips
Tradeshows / Events Video Cards Web News
   Looking for something a little farther back? Try PCstats News Archives: 1999 - present
   10 / 15 / 2019 | 6:18PM
Hardware Sections 

PCSTATS Network Features Information About Us Contact
PCSTATS Newsletter
ShoppingList Assistance
Tech Glossary
Technology WebSite Listings
PermaLink News
Archived News
Submit News (Review RSS Feed)
Site Map
PCstats Wallpaper
About Us
Privacy Policy
Advertise on PCSTATS

How's Our Driving?
© Copyright 1999-2019 All rights reserved. Privacy policy and Terms of Use.