Excel sorting
Closed
Rohanagain
-
8 Sep 2011 à 16:00
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 9 Sep 2011 à 00:02
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 9 Sep 2011 à 00:02
Related:
- Excel sorting
- Excel mod apk for pc - Download - Spreadsheets
- Vat calculation excel - Guide
- Kernel for excel repair - Download - Backup and recovery
- Arrow keys not working in excel - Guide
- Excel clear formatting - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
9 Sep 2011 à 00:02
9 Sep 2011 à 00:02
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
