More share buttons
Share on Pinterest

How to Add Quotes to Your Cells in Excel Automatically

This tip is going to be mostly helpful to people who working with databases. But, if you work with Excel and find yourself needing to deal with repetitive formatting, you might also appreciate the technique.

When working with CSV files you may need to add quotes to either side of a cell’s contents in order to upload them properly to your database. You can easily find yourself working with an Excel file from a workmate that needs to be formatted.

You got this:

But really need this:

This can be a big damn deal if you have hundreds of fields. No one wants to add this by hand. Fortunately, the solution is a snap! It all has to do with applying specific formatting to your cells.

  • Highlight the cells you want to add the quotes.
  • Go to Format –> Cells –> Custom
  • Copy/Paste the following into the Type field: \”@\”
  • Click “okay”
  • Be happy you didn’t do it all by hand.

NOTE: It’s always a good idea to open your file in a text editor to double-check your CSV export. Sometimes you need to do a little find/replace action to get your file picture perfect.

Share on Pinterest
Share with your friends










Submit

Did you like this article? Have questions? Wanna boost your karma?

Join the discussion...

If you have any questions
about this article join the
discussion on Facebook:

Facebook! ►►

Tell Your Friends...

If you found this article
helpful, consider sharing
it, or hitting some of those
social media buttons
to give me a little boost!

Join My Mailing List!

I'd be delighted if you
joined my mailing list
for more helpful
tips and tricks.

What people are saying...

Interested in working with Lena? Check out some of her client testimonials below!

In designing a website, Lena “gets it”. I can feel confident that when I’m not able to communicate what I need with the correct lingo, she can still determine what I’m trying to accomplish  and will offer up suggestions on how to meet those objectives.

Carolyn Klucha

Owner, CK Direct

Carolyn Klucha

Lena is a highly-talented graphic designer and artist. The work she has done for me has been very creative  and yet professional. She understands my likes and dislikes when she designs marketing materials for me and  her understanding of technical issues, software programs, and cross-platform of operating systems is a real asset.  She’s also fun to work with, you can’t beat that combination!

Kim McDougal

Designer

Kim McDougal

Lena is a dream to work with. She interprets her clients’ needs and direction efficiently, and turns out good, clean concepts every time.

Nancy White

Girl Scouts of Gateway Council

Nancy White