I am attempting to create a file system using excel that can be easily
searched and sorted by a number ie 1.3.12 or alphabetically. At this time I
have entered the data as I would like it to appear if sorted by number,
however if I attempt to alphabetize I can not restore the numbers to their
proper order.

Currently I have only 3 columns. One with numbers, one with file names, and
one with additional information.

For example

1 Office
1.1 Employees
1.1.1 Bob Marketing
1.1.2 Dave IT
€¦
1.1.12 Joe Marketing
1.2 Equipment
1.2.1 Computers
€¦.
12 Locations
12.1 USA
12.1.1 New York
12.1.1.1 New York Primary
12.2 New Mexico
12.2.1 Albuquerque Primary
€¦
12.2.15 California
12.2.15.1 L.A. Secondary
€¦

Is there any way I can sort these alphabetically using the other two columns
and then get back to the proper numbering? A question that seems to be
similar or related to this can be found he
http://www.excelforum.com/showthread...hreadid=401416

Thanks,
-Ian