At my work, there are several excel sheets, now I want to sort on colum
A.
But it needs to be sorted on the length of the record with the longes
entree first.

For example:

a dog
a very small dog
a small dog

Needs to be sorted as:
A very small dog
a smaal dog
a dog.

Is this possible, how can I sort this.

JHP

--
jhp
-----------------------------------------------------------------------
jhpk's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=26137

Hi
see your post in Excel.misc

--
Regards
Frank Kabel
Frankfurt, Germany


jhpk wrote:
At my work, there are several excel sheets, now I want to sort on
column A.
But it needs to be sorted on the length of the record with the
longest
entree first.

For example:

a dog
a very small dog
a small dog

Needs to be sorted as:
A very small dog
a smaal dog
a dog.

Is this possible, how can I sort this.

JHPK