I have two Columns, The first column has 5-10 paragraphs of text. Second Column has some data separated by commas. I wanted to merge these two data in the column into a new column. The Idea I had was to replace all the newline character in the first column with data from the second column until a comma. How to do this using formulas or VBA scripts?