Insert big text into multiply rows by keyword into Excel or google spreadsheets

Solution 1:

Edit your original text and wrap all the lines you want in a single cell in quotation marks. The result should look like this:

"Line:
x1 = 10, y1 = 100
x2 = 30, y2 = 40"
"Line:
x1 = 100, y1 = 120
x2 = 130, y2 = 140"

How you do this is dependent on what you use to edit text. If I was using notepad++, I would find and replace like this:

Be sure to check the first and last lines of your text manually. If the replace I did above, it would have missed those two lines since they don't fit the pattern.

Once your text has quotes in it, you can copy / paste into Excel and it'll recognize everything between quotes as belonging in the same cell although it may not automatically resize rows and columns to fit your new data.