Assume the values start in A1, in B1 put

=IF(ISERR(--A1),--LEFT(A1,MATCH(FALSE,ISNUMBER(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),0)-1),A1)

entered with ctrl + shift & enter

(if column B or the adjacent column is not available insert a new column to
the right and put the formula there adapted to your real values)

copy down as long as needed then select both columns and sort by the help
column

--
Regards,

Peo Sjoblom

(No private emails please)


"BrettOlbrys"
wrote in message
...

It's not feasable to sort in Word b/c I have 200+ pages like this to
sort. The data was not imported, it was typed directly into the
cells.

I simply want the data to ascend from lowest to highest just like the
Word example above, so how do you do in Excel when there is text in
there too?

Thanks,

Brett


--
BrettOlbrys
------------------------------------------------------------------------
BrettOlbrys's Profile:
http://www.excelforum.com/member.php...fo&userid=1786
View this thread: http://www.excelforum.com/showthread...hreadid=496583