Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to sort number in alphanumeric

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

like image 536
drop Avatar asked Apr 12 '10 02:04

drop


People also ask

How do you sort a number with a letter prefix in Excel?

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.

How do I format alphanumeric in Excel?

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.


1 Answers

Fantastic, well-optimized open source solution at http://dotnetperls.com/alphanumeric-sorting

like image 191
sblom Avatar answered Sep 28 '22 12:09

sblom