Hello,

Is there an easy way to sort a list with varying lengths of data?

We have a column that has data in the cells that are say 4-9 characters
in length. What currently happens when we sort is it sorts all the 4
character length entries first, then the 5 character entries, and so
on. We would like to sort it so it is alphanumeric based on the
characters it contains...regardless of length.

Thanks in advance!


--
couriced
------------------------------------------------------------------------
couriced's Profile: http://www.excelforum.com/member.php...o&userid=26900
View this thread: http://www.excelforum.com/showthread...hreadid=475956