How to sort file numbers using Microsoft Excel 2010 ?

Question

Please help me to sort a list of file numbers using MS Excel 2010.
Operating Syatem - Windows 7

Here is a sample.
The column heading is file number.
It consists of set of file numbers.
After sorting the file numbers the result is also shown in the sample.


File Number

H/10191/2003
H/2101/2006
H/12546/2012
H/10/2001
H/1421/2006
H/1429/2003
H/245/2001


------ ------ ------ ------ ------ ------
Result after sorting should be as follows
------ ------ ------ ------ ------ ------

File Number

H/10/2001
H/245/2001
H/1429/2003
H/10191/2003
H/1421/2006
H/2101/2006
H/12546/2012

Waiting for ur valuable solutions ..

Answer 1

1. Select the whole sheet.

2. Click Data > Sort.

3. Under "Sort By," click Column A

4. Under "My data range has," select "Header rows." Press OK.



A message then appears, stating: "The following sort key may not sort as expected because it contains some numbers formatted as text: [Column A's name]. What would you like to do?"



5. Select option 2, which is "Sort numbers and numbers stored as text separately."



Bam. It is that easy.

Answer 2

Separate the data into the three columns using the Data - Text to Column feature and use the "/" as the delimiter.



Then sort on the 3rd column (Yr) in ascending order followed by the middle series of numbers also ascending....



That will get you the order wanted/indicated......... If you wish to put back together as originally set you can use the Concatenate Function and re-insert the "/"

Answer 3

Try below steps:

Select a column of numeric data in a range of cells, or make sure that the active cell is in a table column containing numeric data.

On the Data tab, in the Sort & Filter group, do one of the following:

To sort from low numbers to high numbers, click Button Image Sort Smallest to Largest.

To sort from high numbers to low numbers, click Button Image Sort Largest to Smallest.

Issue: Check that all numbers are stored as numbers If the results are not what you expected, the column might contain numbers stored as text and not as numbers. For example, negative numbers imported from some accounting systems or a number entered with a leading ' (apostrophe) are stored as text. For more information, see Convert numbers stored as text to numbers.

Answer 4

Generally, ms office 2010, including excel, saves in the same xlsx, docx, pptx etc, format, which is supported in 2007 as well. So there is really no compatibility issue. OR you can save as 03, but that's basically how it works.

Answer 5

I would separate the numbers into three different columns, then sort all the data by the new columns.

----------------

Choose 3 new columns (you can insert columns right next to the "File number" column if you wish).

I assume the "File number" column is column A, the first number is in row 2 and the new columns are B, C and D. If this is not true, adjust the formulas as needed.



Copy this formula and paste it into cell B2:

=LEFT(A2,SEARCH("/",A2)-1)



In C2 put this:

=MID(A2,SEARCH("/",A2)+1, (SEARCH("/",A2, SEARCH("/",A2)+1)- SEARCH("/",A2)-1))



In D2 put:

=RIGHT(A2,LEN(A2)- SEARCH("/",A2, SEARCH("/",A2)+1))



Sort all the data by these columns. Your original data column will now be sorted as you wanted. You can then delete the new columns B, C and D.



. .

Answer 6

complex situation. query over yahoo and bing. that could actually help!