Select the column with the name and DataSortAscending.

I'm sure there must be more to this than you have posted.

Are the names in a column by themselves like

Adams
Zygote
Dipthong
Coors

Or are they embedded in a cell with other names or numbers like

123Adams
Morley Zygote
Willard Dipthong
A1 Coors


Gord Dibben Excel MVP

On Wed, 11 May 2005 11:26:02 -0700, HOW CAN I SORT BY ALPHABETICALLY FROM A
<HOW CAN I SORT BY ALPHABETICALLY FROM A @discussions.microsoft.com wrote:

HOW CAN I SORT BY ALPHABETICALLY FROM A TO Z BY LAST NAMES PLEASE