Are you a reporting analyst in IT firm, network engineer, networking analyst or any one who works on network data? If yes, then you ever tried to sort TCP/IP Addresses, I'm sure something like red list in this figure, would have happened and you must have desired the green list. This is the issue of sorting with delimited numbers like 1.1.2, 1.1.1, 1.1.10 which results in 1.1.1, 1.1.10, 1.1.2.
Generally, computer and languages on which computers operate treat them as string literals and sorting is based on their ASCII character number. So, the solution is to normalize them, sort them and denormalize back in their original form. This is how, the given VBA macro works. Hope, you understand it easily and leave any questions for clarifications in the comments section. CLICK HERE FOR THE VBA MACRO CODE<http://www.excelitems.com/2011/06/sort-tcp-ip-address-excel-delimited-vba.html> Best Regards, Ashish Jain Facebook <http://www.facebook.com/eXceLiTems>/ eXceLiTems<http://www.eXceLiTems.com> +91 - 9999 - 40 - 48 - 43 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
