I guess that this is going to sound like a simple question but it has me beat.
I am using Excel 2000 for a name study project.
Currently there are 3100 rows and 22 cols. A mixture of text, date and numeric columns.
Apart from one column all others sort in order.
The column that will not sort correctly is the one with the forenames in it.
Currently I get, for example:
John
John
John
John Albert
John Frederick
John George
John William
John
John
Jonathan
I have formatted all cells to Text
Justified the text to the left
but still it will not sort in strict alpha order.
The same file on other PCs using Excel 2003 and Open Office displays the same problem, thus it is my file that is the issue.
Some of the data was imported from screen captured data, so I wonder if the spreadsheet has picked up some hidden coding that gives rise to the issue.
Ideas on how to get around this issue, anyone ?
Thanks
Casey
I am using Excel 2000 for a name study project.
Currently there are 3100 rows and 22 cols. A mixture of text, date and numeric columns.
Apart from one column all others sort in order.
The column that will not sort correctly is the one with the forenames in it.
Currently I get, for example:
John
John
John
John Albert
John Frederick
John George
John William
John
John
Jonathan
I have formatted all cells to Text
Justified the text to the left
but still it will not sort in strict alpha order.
The same file on other PCs using Excel 2003 and Open Office displays the same problem, thus it is my file that is the issue.
Some of the data was imported from screen captured data, so I wonder if the spreadsheet has picked up some hidden coding that gives rise to the issue.
Ideas on how to get around this issue, anyone ?
Thanks
Casey