First, thank you for your help.
Hope this time I can explain it better.
My initial request was based on the possibility to sort the following information (including the prefixes numbers).
1. ACA-88026 ......
2. ACA-11001 ......
3. ACA-05560 .....
My second request was for the possibility of sorting the same information without the prefixes, and without having to reinstates the prefixing.
ACA-88026 ......
ACA-11001 ......
ACA-05560 .....
So, after applying the macro or code, the output should looks like the one below (also with their associated text):
ACA-05560
ACA-11001
ACA-88026
I think with this new information I should be able to try something new with a document that I'm working with.
Thanks!
|