Problem with sorting

**To.mek** · 09-24-2013, 04:58 AM

Hi all,
I have a problem with sorting. What formula should I use to change:

1.1.7
1.1.8
1.10
1.11
1.12
1.2

into:

1.1.7
1.1.8
1.2
1.10
1.11
1.12

it was just an example. I suppose it is a common problem.

**XOR LX** · 09-24-2013, 05:15 AM

Hi,

Not entirely sure since you give limited examples, but perhaps, assuming your first entry is in A2, enter this in B2 and copy down as required:

=LEFT(A2,FIND(".",A2)-1)+MID(A2,FIND(".",A2)+1,255)/10^3

Now sort ascending on this new column.

Regards

**ragulduy** · 09-24-2013, 05:20 AM

I'm not sure how to do it with formulas but in case it is of any use you could maybe use a macro along the lines of:

Please Login or Register  to view this content.

**To.mek** · 09-24-2013, 05:35 AM

Here's a thing:
How it should be done: (proper_version)
and how it looks like after sorting: (after_sorting).
I just dont know how i can go back to proper version.