How to sort SR4.2-10,11,8,9 to SR4.2-8,9,10,11 by VBA

Unfortunately you need to break down the cell into its component parts, and then format the numerical elements so that they are the same length, otherwise it sorts numbers like text, which is what is causing you the problem.
This formula will convert the string in one go (assuming there are always 2 alpha characters in positions 1 and 2

Formula:

Please Login or Register  to view this content.

And you can use this value to sort in the usual way

In the attached workbook I have broken that formula down for you in separate columns which may be easier to follow!

Hello london7871,

Here is another approach with VBA. I have used the Macro Recorder which will hopefully make it easier for you to understand. You may play around with it and change your ranges to suit.

Please Login or Register  to view this content.

I have moved the Data Range down to start at Row3. All you now need to do is to hit on the "Click Me" - button in the attached sample Workbook below.

HTH

Regards.

You could use a UDF in an extra column and sort by that:

Row\Col	A	B	C
1	Input	Sort
2	SR4.2/10	SR04.02/10	B1: =padnum(A1, 2)
3	SR4.2/11	SR04.02/11
4	SR4.2/8	SR04.02/08
5	SR4.2/9	SR04.02/09

Please Login or Register  to view this content.

Hello london7871,

I have adapted the Code to allow for any length of Data in ColumnA. Please replace the Code in the sample Workbook in Post #3 with the Code below:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Regards.

Hi London7871

Here's another approach...

Please Login or Register  to view this content.

Hi london7871,

You were offered you a couple of solutions to your original request, without you acknowledging any of them. I don't think I will be far off by saying, that members might be less inclined to try and help you again.

Common courtesy could earn you some respect, if you at least thank one or more of the contributors to your original request, and then hopefully you may receive further assistance.

In Post #8 you could add something like:

Hi guys,
Thank you for all your help. Sorry but could we expand it to "How to sort different format as below as per attached excel:
SR4.3/8,9; SR4.2/10,11,7+1,7A to SR4.2/7A,7+1,10,11;SR4.3/8,9 ?"

Thank you for your understanding.

Regards.

Hi london7871,

Thank you.

Please confirm if the numbers SR4.3/8,9; SR4.2/10,11,7+1,7A as per your new sample Workbook are the only values of interest, or may there be other variations?

Regards.