Search code examples
excelquotes

Paste quoted elements into Excel without loosing quotes


I'm trying to copy three lines of quoted words into Excel.

Things to copy

But when I paste them the quotes are automatically deleted!

auto-deleted

Does anyone know how to keep the quotation marks on Excel?


Solution

  • Highlight the cells you want to add the quotes:

    1. Right click Go to Format Cells –> Custom

    2. Copy/Paste the following into the Type field: \”@\”

    3. Click “okay”