sort and special chars

H

hedrew3

I am trying to sort a list of names. The problem is that some last
names start with accented characters -- for ex., Á (Alt 0193), etc.

It turns out that XL seems to ignore accented characters in its
sorting algorithm.

Any one know a way around this?

TIA

Pete
 
D

David McRitchie

Hi Pete,
Looks to me like they are sorting properly all the A's appear
together, all the O's appear together.

insert a new worksheet
A1: =CHAR(ROW()+32)
B2: =ROW()+32
name box: A1:B223 the name box is to left of the formula bar.
Ctrl+D to fill down as with the fill handle
With A1:B223 still selected...
Ctrl+C to copy
Edit, Paste Special, Values
with any cell in column A as the active cell
Ctrl+A select all cells the cell in Column A should still be the active cell.
use the Sort Ascending Key

I have a page on sorting (sorting.htm) though I don't think you need
it for this as I think you must have another problem, but I have no idea
what it might be since you can't change.

Also tested by sorting a string with the 3rd character changed to
make sure same results from a word as from a single character
as far as letters being together. And included a 3 digit random
number to change the sorting before sorting on another column.
 
Top