You may want to re-think this.

Dav's suggestion works fine if the data from Column A to Z is already
alphabetically arranged.

If not, perhaps you could try entering the numbers 1 to 26 across A to Z and
sort left to right on them.


Gord Dibben MS Excel MVP

On Wed, 12 Jul 2006 00:08:01 -0700, Bruce
wrote:

Great, thanks Dav

"Dav" wrote:


Just sort the columns, Choose data_sort and in your options you can sort
left to right rather than top to bottom which is the default.

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=560564