HOW DO I SORT ALPHABETICALLY SO THAT DOUBLE LETTERS (AA) FOLLOWS Z INSTEAD OF
AFTER THE SINGLE A.

If your data always consists of one character or two characters, you could add a
formula to an adjacent column:

=len(a1)
and drag down

Then sort using this column as your primary key and the original column as your
secondary key.

Maureen wrote:

HOW DO I SORT ALPHABETICALLY SO THAT DOUBLE LETTERS (AA) FOLLOWS Z INSTEAD OF
AFTER THE SINGLE A.

--

Dave Peterson

How about in Word?

"Dave Peterson" wrote:

If your data always consists of one character or two characters, you could add a
formula to an adjacent column:

=len(a1)
and drag down

Then sort using this column as your primary key and the original column as your
secondary key.

Maureen wrote:

HOW DO I SORT ALPHABETICALLY SO THAT DOUBLE LETTERS (AA) FOLLOWS Z INSTEAD OF
AFTER THE SINGLE A.

--

Dave Peterson

That would be better asked in an MSWord newsgroup.

(I don't have any idea.)

Maureen wrote:

How about in Word?

"Dave Peterson" wrote:

If your data always consists of one character or two characters, you could add a
formula to an adjacent column:

=len(a1)
and drag down

Then sort using this column as your primary key and the original column as your
secondary key.

Maureen wrote:

HOW DO I SORT ALPHABETICALLY SO THAT DOUBLE LETTERS (AA) FOLLOWS Z INSTEAD OF
AFTER THE SINGLE A.

--

Dave Peterson


--

Dave Peterson

You don't need to shout. We can hear you.

You will need to get your data into a form that Excel Sort understands. One
option would be to create a helper column that creates sortable cells. Depending
on what your data looks like, it could be a simple as inserting a Z in front of
all double letters.

--
Regards,
Fred


"Maureen" wrote in message
...
HOW DO I SORT ALPHABETICALLY SO THAT DOUBLE LETTERS (AA) FOLLOWS Z INSTEAD OF
AFTER THE SINGLE A.