The problem: I have a file which has Name of the book (Column A), Chapter number (Column B), colon (Column C). verse number (Column D) and the text (Column E). All of these are then combined in Column F for the final results. The problem is inserting the chapter numbers.
Possibility one: Most of the time I have the beginning chapter number which appears in Column D, before the next chapter. If it is possible to read the new number in Column D and fill in the following cells in Column B until the next change of number in Column D.
Possibility two: Read the change in verse number from Column E when it starts over at 1 and change the chapter number up by 1 filling in the cells of Column B with that new number until the next number 1 comes up in Column D.