Input:
SHC 111U,SHB 22x,, SHA 5555G
Needed output:
SHB 22X, SHC 111U, SHA 5555G
I have to sort only Vehicle no
in the Parking Area not prefix and suffix letter
1. Select a blank cell beside the numbers with letter prefix or suffix, says Cell B2, type the formula =EXTRACTNUMBERS(A2,TRUE) (A2 is the cell of number with letter prefix or suffix) into it, and then drag this cell's AutoFill Handle to the range as you need. See screenshot: 2.
1. Select the column you want to limit the entry, and click Data > Data Validation > Data Validation. 3. Click OK, and then the selected column only allowed entry numeric characters.
Fantastic, well-optimized open source solution at http://dotnetperls.com/alphanumeric-sorting
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With