Hi,
I have several hundred entries in an Excel spreadsheet that I need to sort alphabetically from A-Z. Sounds easy eh, but...
The problem is that EVERY entry starts with 8 numerical digits, 3 alphabet characters and an underscore followed by a string of letters.
eg: 20130201ABC_jackson_bob
It is the string after the first underscore that I need Excel to sort from A-Z not the number before it as it tries to do!
Is there a way to customise the cells so that it ignores the first 12 characters or or do I need to write a Macro (VBA) to do this
Tnx for any help you may have.
I have several hundred entries in an Excel spreadsheet that I need to sort alphabetically from A-Z. Sounds easy eh, but...
The problem is that EVERY entry starts with 8 numerical digits, 3 alphabet characters and an underscore followed by a string of letters.
eg: 20130201ABC_jackson_bob
It is the string after the first underscore that I need Excel to sort from A-Z not the number before it as it tries to do!
Is there a way to customise the cells so that it ignores the first 12 characters or or do I need to write a Macro (VBA) to do this
Tnx for any help you may have.