Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting text & numbers
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting text & numbers
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting numbers with text | New Users to Excel | |||
Help sorting text as numbers | Excel Worksheet Functions | |||
Sorting (Numbers with Text) | Excel Discussion (Misc queries) | |||
Sorting numbers as Text | New Users to Excel | |||
SORTING TEXT AND NUMBERS | Excel Worksheet Functions |