thanks for you help, but i've noticed another dilemma. It now adds a part of the next question or answer to the previous. Notice the attached excel file. In C column I demarcated (In red) the unnecessary part that is being added to every question
Maybe an idea.. now that we know where the position of the first line for each question is. Maybe we can extract everything between those first lines and using a new much more simple formula lets say in column C?
Bookmarks