Sorting in Excel

  • Thread starter Thread starter gp
  • Start date Start date
G

gp

Hi all,

I would like to do the following sort in excel, wondering
how?

Before sort
45
14,15
78
50
12
65
55,56


After sort I need to get:
12
14,15
45
50
55,56
65
78


Is this possible in excel?

Thanks in advance
 
Not without using a help column and a formula that extracts the digits
before the comma,

=IF(ISNUMBER(A1),A1,--LEFT(A1,FIND(",",A1)-1))

copy down and the sort ascending by the help column
 
Back
Top