View Single Post
  #3   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

You could create a helper column which removes the ** and sort on that.

"silver fox" wrote in message
...
I have a column of data (Excel 2000) which I would like to sort
alphabetically. Some entries have a double asterisk preceeding the first
word (**word). I would like to alphabetize ignoring the double asterisk.