Excel sorting
Closed
Rohanagain
-
Sep 8, 2011 at 04:00 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 9, 2011 at 12:02 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 9, 2011 at 12:02 AM
Related:
- Excel sorting
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
- How to take screenshot in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 9, 2011 at 12:02 AM
Sep 9, 2011 at 12:02 AM
for example email addresses are ther in A1 down
in B1 type this formula
=RIGHT(A1,LEN(A1)-SEARCH("@",A1))
copy B1 down
highlight both A and B column and sort according to column B (in this case "no header row")
if you want after sorting you can delete column B
in B1 type this formula
=RIGHT(A1,LEN(A1)-SEARCH("@",A1))
copy B1 down
highlight both A and B column and sort according to column B (in this case "no header row")
if you want after sorting you can delete column B
