sorting cells with numbers and letters
 

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!

sorting cells with numbers and letters
 

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

"Bridget" wrote in message
...
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!

sorting cells with numbers and letters
 

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!

--------------------
(MS-Exl-Learner)
--------------------



"Bridget" wrote:

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!