Paste formatted SQL queries from text file into Excel (one Excel row for each query)

[Blue1971]

I have a .TXT text file that has formatted SQL queries in it.

--The corresponding Excel row ID is: 2
select
    main.active_transportation.objectid,
    main.active_transportation.type,
    main.active_transportation_nt_flag_vw.objectid,
    main.active_transportation_nt_flag_vw.flag
from
    main.active_transportation
left outer join main.active_transportation_nt_flag_vw on
    main.active_transportation.objectid = main.active_transportation_nt_flag_vw.objectid
where
    main.active_transportation.objectid in ( 49996, 49997, 49998, ... );
--The corresponding Excel row ID is: 3
select
    main.active_transportation.objectid,
    main.active_transportation.type,
    main.active_transportation_nt_flag_vw.objectid,
    main.active_transportation_nt_flag_vw.flag
from
    main.active_transportation
left outer join main.active_transportation_nt_flag_vw on
    main.active_transportation.objectid = main.active_transportation_nt_flag_vw.objectid
where
    main.active_transportation.objectid in ( 14113, 14114, 14115, ... );
--The corresponding Excel row ID is: 4
select
    main.active_transportation.objectid,
    main.active_transportation_nt_flag_vw.flag
from
    main.active_transportation
left outer join main.active_transportation_nt_flag_vw on
    main.active_transportation.objectid = main.active_transportation_nt_flag_vw.objectid
where
    main.active_transportation.objectid in (54081, 54082, 54083, ...);

I want to copy the text from a text editor and paste it into Column D in an Excel 365 spreadsheet.

Each query would be inserted into it's own cell/row. Like this:

---

Regarding the SQL comments in each query:

--The corresponding Excel row ID is: 2

It would be ideal if the SQL comments were removed. But it's ok to leave them in if it's too hard or messy to get rid of them.

It would also be ideal if the SQL spacing were visible -- without the need to double-click a cell to see the proper spacing. But again, that's not necessary if it's not practical.

---

How can I paste the formatted SQL queries into Excel? (one Excel row for each query)

 

[Micron]

Maybe this for the line wrapping part?

Start new line in Excel cell - 3 ways to add carriage return

Three ways to insert a line break in Excel cell: enter multiple lines with a shortcut, use a formula to combine values from individual cells each starting in a new line, add carriage return after a specific character with Find & Replace.

www.ablebits.com

As for row/column sizes, selecting the column divider and double clicking it will size the width. Same for the row dividers when rows are selected.
As for the comments, not sure what would work. If you could find them based on green text (are they green in the results?) you run the risk of deleting text you want to keep. Also wondering if Instr function could find the line based on first finding -- then finding a line wrap and getting the length between those 2 points. Seems kind of dangerous though.