You could split up the book, chapter and verse into multiple columns

or maybe you could reenter your chapter and verses to include leading 0's.

John 03:016-017

Include enough leading zeros for the worse case.



Sue McDonald wrote:

I am working with a church database and I need to sort in one column by
scripture (John 3:16-17). I am able to do the alphabetical sort but it will
not do the chapter sort after that. It goes from chapter 1 to chapter 10
then to chapter 2. Does anyone have any suggestions?
--
Thanks,

--

Dave Peterson