Forum Discussion

kbgriggs's avatar
kbgriggs
Copper Contributor
Jun 25, 2020

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...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 25, 2020

kbgriggs 

That could be like

if apply Wrap text 

  • kbgriggs's avatar
    kbgriggs
    Copper Contributor
    Jun 25, 2020

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

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jun 25, 2020

      kbgriggs 

      I see. Here to copy/paste from the site I used Paste as HTML, another sample is copy/pasting as HTML from Word

      Not sure how it will work with other sources.

Resources