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

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.

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