Pasting SQL formatted code into Excel cell

Question

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 paste into a single cell by pasting into the format bar, it strips the formatting.

Here is a dummy sample of formatted code I am trying to paste:

SELECT DISTINCT field
FROM tablename (NOLOCK)
WHERE field Like 'L%' --Reasons starting with "L", per J.Doe

sergeibaklan · Answer

kbgriggs&nbsp;
That could be like

if apply Wrap text&nbsp;

bennadeau · Answer

Hi&nbsp;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&nbsp;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.&nbsp;Ben&nbsp;

kbgriggs · Answer

Hi&nbsp;SergeiBaklan!&nbsp; Thank you for your response.&nbsp; I am able to paste into the cell.&nbsp; What I am trying to figure out is a way to paste it so that my formatting stays.&nbsp; Here is an example of what I want it to look like in Excel.&nbsp; Currently, I am having to reformat word by word to get the colors I need for the code.&nbsp;