+ Reply to Thread
Results 1 to 2 of 2

Help! Help! Help! Cannot save *.csv file to *.xls file format.

  1. #1
    Registered User
    Join Date
    04-02-2015
    Location
    Bengaluru
    MS-Off Ver
    2010
    Posts
    1

    Post Help! Help! Help! Cannot save *.csv file to *.xls file format.

    Hi

    I open the CSV file (Source of the file is WWW), although the required format is present when view through the web but when saved, all the entries appear in first column i.e., all the formatting is erased. Now I use Text-to-Columns to delimit the single column format but then when I try to save the same file into *.xls I can't see any excel format. All I can see is a *.txt format. Any way to fix this?

    Already tried the following but resulted in nothing:
    http://kb.paessler.com/en/topic/2293...ay-to-fix-this

    http://superuser.com/questions/40708...ommas-in-excel

    MS Excel: 2010
    Region: USA

  2. #2
    Forum Contributor
    Join Date
    12-11-2010
    Location
    Indiana, USA
    MS-Off Ver
    Excel 2007
    Posts
    118

    Re: Help! Help! Help! Cannot save *.csv file to *.xls file format.

    Try saving it in a note pad, then open this (.txt) file through excel, and use the delimited option ...

+ 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. Save as macro that specifies file type, file location and takes file name from three cells
    By ExcelFailure in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-13-2013, 10:09 PM
  2. Replies: 0
    Last Post: 01-27-2013, 12:13 PM
  3. Replies: 1
    Last Post: 01-16-2013, 02:02 AM
  4. How to: Open file, format data, save file, close file and repeat.
    By thexeber in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-11-2010, 12:56 PM
  5. [SOLVED] Save excel file as another format file
    By ExcelReport in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-12-2005, 09:06 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