I need to sort an Excel sheet by the end of text string. There is only one column in use and I need the column sorted by the last 9 characters.
What this will do for me is put specifics together (all EISENTECH together) etc.
Sample of rows (only one column):
0764113437 (pbk.) : $12.95 ACK-5914 LCMARC/AZB-7318/PATTECH
0936894547 (pbk.) : $15.95 LCMARC/ARX-4511/EISENTECH
0865425833 (pbk. : alk. paper) 249953 (DNLM)100969828
0778800547 : $18.95 ACE-0539
0070504563 (pbk.) ABJ-6152 DBSRVR::LCMARC/ATS-5732/EISENTECH
Any suggestions? How do I go about this?
Thanks