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.