Thread: Sort feature
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
James Silverton James Silverton is offline
external usenet poster
 
Posts: 182
Default Sort feature

Hello, CLR!
You wrote on Mon, 8 Jan 2007 09:31:01 -0800:

C =LEN(A1)

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

C then sort on the helper column, ascending

It seems to work without the Paste Special complication :-)

C " 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
??

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not