Hello!

I'm hoping one of you can help me straight-away. I am working in Excel 2003 (created in E2010) on a collaborative review of a large scientific document. There will be several other people contributing to the spreadsheet.

I would like each entry to reference the chapter and page of the original document. Preferably, that reference would be something like 7-317 for Chapter 7, p. 317 (each of the pages of the 11 chapters of document we're reviewing begins with page 1 so page numbers by themselves are not unique. One caveat is that there are several appendixes. I'd like to designate them similarly, but with an "A" to denote the Appendix number (e.g. A3-23, for Appendix 3, page 23).

So that each collaborator does not have to insert rows so that all our comments are sequential, I would like to be able to sort the comments according to the 'chapter-page' numbers so that when submitted for evaluation, they are sequential.

So far, I have been unable to locate any tips to help me with this. I realize I could separate the Chapter and Page into separate columns, but I'm not sure if I sorted on those two columns simultaneously that the proper chapter-page combinations would be retained.

Is there a formatting I can use so that I can have reviewers designate a Chapter-Page in a single cell so that those cells can be used to sort a large group of comments into sequential order?

Thanks in advance for the help!