I've a long list of data (1500 cells) in the following format:
AK1
AK2
BL1
BL100
BL2
BL173
WSB1
WSB20
NK1
NK100
NK40
I need to sort this data so that the 'alpha' part (upto 3 char) is in alphabetic order and 'numeric' part (upto 3 char) is in logical number sequence and the result is displayed in the same cell. as below.
BL1
BL2
BL100
NK1
NK40
NK100 AND SO ON.
I've tried to find the solution from excel formulas and even asked for professional help.but no success achieved.
Someone pl.Help.
AK1
AK2
BL1
BL100
BL2
BL173
WSB1
WSB20
NK1
NK100
NK40
I need to sort this data so that the 'alpha' part (upto 3 char) is in alphabetic order and 'numeric' part (upto 3 char) is in logical number sequence and the result is displayed in the same cell. as below.
BL1
BL2
BL100
NK1
NK40
NK100 AND SO ON.
I've tried to find the solution from excel formulas and even asked for professional help.but no success achieved.
Someone pl.Help.