I have a spreadsheet that I need help sorting. It has 8 columns and I need to sort all the data by column A. I have formatted the alphanumeric column to text and tried to sort. I have tried Text to Columns and that did not work either.
I have attached the file but if I didn't do it correctly here is an example of what I am dealing with.Power 3 P&ID 1035.xls
B1-10-1035.dgn
B1-101-1035.dgn
B1-102-1035.dgn
B1-103-1035.dgn
B1-104-1035.dgn
B1-105-1035.dgn
B1-106-1035.dgn
B1-107-1035.dgn
B1-108-1035.dgn
B1-109-1035.dgn
B1-110-1035.dgn
B1-1-1035.dgn
B1-111-1035.dgn
B1-112-1035.dgn
B1-140-1035.dgn
B1-141-1035.dgn
B1-15-1035.dgn
B1-16-1035.dgn
B1-16A-1035.dgn
B1-17-1035.dgn
B1-1A-1035.dgn
B1-1B-1035.dgn
B1-1C-1035.dgn
B1-1D-1035.dgn
B1-1E-1035.dgn
B1-1F-1035.dgn
B1-20-1035.dgn
B1-210-1035.dgn
B1-2-1035.dgn
B1-21-1035.dgn
B1-211-1035.dgn
B1-212-1035.dgn
I need them to be:
B1-1-1035.dgn
B1-1A-1035.dgn
B1-1B-1035.dgn
B1-1C-1035.dgn
B1-1D-1035.dgn
B1-1E-1035.dgn
B1-2-1035.dgn
like that..... Please help.
Bookmarks