Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a dataset with the complete text of the Greek Novum Testamentum (New Testament); see an image here.

Each line is one verse.  I will find the book and chapter boundaries with the help of these statistics.

I want to import this into Calc. (I love Calc - since it makes very very easy to search for verses.)  How can I organize the text in Calc to reflect the book/chapter structure of the source document?

share|improve this question
It would probably be easier if you took the text from a source that hadn't already discarded the book/chapter information. What if you have a slightly different edition? The whole system won't work then. – Janus Troelsen Feb 1 '13 at 19:14
up vote 1 down vote accepted

I would insert a column A containing the book name and a column B with the chapter No. Then I would activate the Autofilter function (Data->Filter->Autofilter) and I would format column C (the verse) to wrap text.

With the autofilter set to view all cells, a search will search everything. With only a few chapters or verses visible a search will only search them.

share|improve this answer
hello dear W_WHALLEY - many many thanks - great ideas. I will do as adviced. – zero Feb 2 '13 at 10:01

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.