+ Reply to Thread
Results 1 to 2 of 2

need advice on formatting issue

  1. #1
    Registered User
    Join Date

    need advice on formatting issue

    We have an excel file, .xls format with 4 columns of data. An example column is:

    "some text here" "1" "23" "NA"

    However, when we open the file in excel and re-save, all of the ""'s around each piece of data dissappear. We receive a message box when saving the first time that says:

    "filename.xls may contain features that are not compatible with Text(Tab delimitted). Do you want to keep the workbook in this format?"

    If we say yes, we lose the "". If we say no, it overwrites the original file with all kinds of strange characters and formatting.

    All we want to accomplish is the deletion of the fourth column(there are many lines) without the removal of the ""s around the data. Any help would be greatly appreciated.

  2. #2
    Forum Contributor
    Join Date
    Sounds like a real problem. I just tried to duplicate it and am unable to with a real Excel file. But, if I use a CSV file that I haved named with .xls file extension, then I can re-create the issue you describe.

    After deleting the column, try saving it as file type CSV (with or without .csv file extension) and see if that helps. No promises. But, I just tried it and it seemed to work for me.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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