The Bible In Excel

I found a text file with the complete King James Version of the Bible. I wrote a few macros and dumped it all into an Excel workbook. Each book is on a separate worksheet, and each verse is in a separate cell.

It has a handy hyperlink table of contents so you can jump to any book. I also wrote some summary formulas to calculate the number of characters in each book, and the average number of characters per verse. Then I added a word count feature: Enter a word and it displays the number of occurrences in each book.

Why? I needed a project to get my head back into Excel. I've become very rusty, but it all comes back quickly.

You can download it here. It's a 1.8 Mb zip file, and it expands to a 6.1Mb Excel workbook.

* * *

Update: The latest version now has a random verse generator! (You must enable macros).