sorting text & numbers
Thanks! Glad I didn't miss an obscure option somewhere. I'll give it a whirl.
Kim
"Gary''s Student" wrote:
You need to isolate the number. If you labels are in column A, then in B1:
=--RIGHT(A1,LEN(A1)-FIND(" - ",A1)-2)
So if A1 has:
fgteyci - 567
then B1 will show
567
Now you can sort columns A & B by B.
--
Gary''s Student - gsnu200858
"Kim" wrote:
How can I sort text followed by a number? My project is creating an
inventory of more than 1200 unnamed jpg's. I have many pictures of an
'event' and need a distinguishing number after the name for sorting purposes.
I have 11 pictures of an event. When I sort I get "name - 1, name - 10,
name - 11, name - 2". Can I get Excel to treat the number following the name
as a number?
I'm using Excel 2007.
Thanks for any help..........
Kim
|