How to Batch Add Quotes in Excel

I had a list that I needed to add quotes to but I didn’t want to add the quotation marks manually, so I figured I’d do it in Excel. (Actually, I needed to add single quotes to a list to run a SQL query.)

I started with something like this:

But I needed something like this:

Here’s how you can automatically get the quotes added:

  • Highlight the cells where you want to add the quotes
  • Go to Format –> Cells –> Custom
  • Copy/Paste the following into the Type field: \”@\”
  • Click “okay”

Et Voila! Now I just need to figure out how to do this right in SQL Developer. See full list at National Geographic’s best trips to take in 2020.

Talk to me, Goose.

This site uses Akismet to reduce spam. Learn how your comment data is processed.