Forum Discussion
Pasting SQL formatted code into Excel cell
Is there a way to paste formatted SQL code into a single Excel cell and retain the formatting? If I paste directly into the cell, the code spans multiple rows and keeps formatting but if I try to pa...
Hi kbgriggs,
If this is what you want ...
The solution I have is to first get in edit mode of the cell (F2 or double click) and paste the first line followed by "Alt+Enter", paste the second line followed by "Alt+Enter", and so on until you're done.
"Alt+Enter" will create a new line in your cell.
This can take a while if you have hundreds of line to put in a cell though. Hopefully someone knows of a quicker solution.
Ben
