+ Reply to Thread
Results 1 to 4 of 4

Garbled Left Column In Excel

  1. #1
    Registered User
    Join Date
    12-03-2006
    Posts
    2

    Garbled Left Column In Excel

    I have excel 2003 & when I import a csv file, the left column is all garbled & not readable.

    The program I used to create the file is called auction yen, which analyses eBay's Want It now
    forum & allows you to save it as a .csv file

    Here are some pics of the file & also a link to download it.

    http://www.smartniches.com/excel.html

    Gary,

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by smartniches
    I have excel 2003 & when I import a csv file, the left column is all garbled & not readable.

    The program I used to create the file is called auction yen, which analyses eBay's Want It now
    forum & allows you to save it as a .csv file

    Here are some pics of the file & also a link to download it.

    http://www.smartniches.com/excel.html

    Gary,
    Hi,

    Not my idea of a .csv

    Try to Open in Notepad and replace

    "<a href=""http://www.anrdoezrs.net/click-1451623-5463217?loc=http://wantitnow-search-desc.ebay.com/ws/search/WantItNowSearch?satitle=

    with "" (nothing)

    then the file should look better.

    hth
    ---

    optionally rename to a .HTML - but that seems to lose the 'Row' definition

    ---
    Last edited by Bryan Hessey; 12-03-2006 at 08:35 PM.
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    12-03-2006
    Posts
    2

    Garbled Left Column In Excel

    Thats a lot of replacing but I'll try it, is there a way to do it in excel 2003.

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by smartniches
    Thats a lot of replacing but I'll try it, is there a way to do it in excel 2003.
    its 1 replace All in Notepad or Excel
    ---

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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