sorting - Sort AlphaNumeric with structured references in Excel

Question

I Have an Excel Sheet with data that looks like that.

Data
x=1.1
x=11.2
x=10.3
x=1.4
x=2.5;2.6
x=2.1
x=4.7
x=6.8
x=6.2;6.3
x=1.10

What i want to do is, to sort the List that it Looks like that.

DataSort
x=1.1
x=1.4
x=1.10
x=2.1
x=2.5;2.6
x=4.7
x=6.2;6.3
x=6.8
x=10.3
x=11.2

I tried to do that with that Formula

=LEFT(Tabelle1[[#this row];[Data]];2) & TEXT(SUBSTITUTE(Tabelle1[[#this row];[Data]];LEFT(Tabelle1[[#this row];[Data]];2);"");"#0.0#")

But that did not work. Can someone give me a hint to the right Direction?

Answer 1

Copy the data into a new column say B If you are using excel 2007 or higher, go to data tab --> text to columns option after selecting your data in B

Here you can choose delimited and it will separate your data into 2 columns. Then apply the sorting based on this column