+ Reply to Thread
Results 1 to 3 of 3

How to automatically put quotes around contents of every cell, incl. blank cells?

  1. #1
    Registered User
    Join Date
    02-13-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    2

    How to automatically put quotes around contents of every cell, incl. blank cells?

    I'm migrating data from Financisto for Android to CashTrails for iOS, and I need to format my CSV file a specific way for conversion to a CashTrails file.

    I'd like to do the following in Excel 2013 (I have access to other versions if I need to):
    1. Highlight a range of cells (i.e. A1-H20)
    2. Apply following action: IF cell has data, add " to beginning of cell and " to end of cell, AND IF cell has no data, place "" in cell.

    This can be done, right? I'm desperate!

    It would look like this in Notepad.
    Before:
    Date,Time,Amount,Category,Tags,Account
    12/31/13,12:00 PM,$3.99,General,,Checking
    12/31/13,12:30 PM,$5.00,Shopping,gift,Cash

    After:
    "Date","Time","Amount","Category","Tags","Account"
    "12/31/13","12:00 PM","$34.99","General","","Checking"
    "12/31/13","12:30 PM","$5.00","Shopping","gift","Cash"

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: How to automatically put quotes around contents of every cell, incl. blank cells?

    Slect the area you wish to process and run this small macro:

    Please Login or Register  to view this content.
    Gary's Student

  3. #3
    Registered User
    Join Date
    02-13-2014
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: How to automatically put quotes around contents of every cell, incl. blank cells?

    Thank you so much! Perfect!

    Everything looked fine in Excel, but after saving and opening in Notepad, there were triple quotes. I just did a find and replace of """ with " and all is well

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Count if array incl blank values as criteria - not working ?
    By fallwire in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-29-2013, 06:06 AM
  2. Replies: 8
    Last Post: 01-28-2013, 01:10 AM
  3. Replies: 0
    Last Post: 09-24-2012, 01:20 PM
  4. [SOLVED] VBA code to automatically clear a cells contents when another cell is empty
    By masso1980 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-25-2012, 10:52 PM
  5. Replies: 4
    Last Post: 06-22-2009, 05:48 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1