(Solved) – Is there a way to write a macro that will loop to text join multiple rows of data in excel?

(solved)-–-is-there-a-way-to-write-a-macro-that-will-loop-to-text-join-multiple-rows-of-data-in-excel?

For example I need to join the text in each of these lines, but the document is thousands of lines so a macro would be ideal. The part that I am stuck on is that I don’t know how to write an if statement in a loop that will link the texts in a paragraph and then jump down to the next paragraph of lines and do the same thing until the end of the sheet. You will notice each of them is delimited with a blank row in between on purpose. Any suggestions on how to do this? The example in cell G2 is how I want each beginning sentence to look.

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *