sorting cells with numbers and letters

[Bridget]

I am looking for a way to sort in Excel 2007 on numerical values when
there is also a letter in the cell. For example to get:

235 X
587 X
023 K
004 X
228 X

into the sort:

004 X
023 K
228 X
235 X
587 X

However, there is no numerical option b/c there are letters and there
doesn't seem to be a wildcard function...

Thanks!

 

[L. Howard Kittle]

In an adjacent cell enter and pull down.

=LEFT(B8,3)

Sort both column by the new column. Dump the new column.

HTH
Regards,
Howard

 

[Ms-Exl-Learner]

If the Numbers are only 3 digits then you can use =LEFT(B8,3), Otherwise when
the numbers are unpredictable in length then use this formula

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

Change the cell reference A1 to your desired Cell.

If this post helps, Click Yes!