In a helper column put this and copy down.....

=LEN(A1)

Then do copy PasteSpecial Values on that helper column.......

then sort on the helper column, ascending

Vaya con Dios,
Chuck, CABGx3



" wrote:

I have a column of names. I want to be able to sort that column from
smallest name to largest name. In other words, Al, sam, dave, brian, george,
michael....etc.

Can anyone help me?

Thank you in advance,
Michael