Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: unwanted + Plus sign spread sheet cells  (Read 5518 times)

0 Members and 1 Guest are viewing this topic.

slambos2500

    Topic Starter


    Rookie

    unwanted + Plus sign spread sheet cells
    « on: September 05, 2016, 10:59:20 AM »
    When I import data  (numbers) from a web site to excel, I get  the + sign in the upper left corner of each cell.   
    How do I remove these + signs ??

    DaveLembke



      Sage
    • Thanked: 662
    • Certifications: List
    • Computer: Specs
    • Experience: Expert
    • OS: Windows 10
    Re: unwanted + Plus sign spread sheet cells
    « Reply #1 on: September 05, 2016, 12:48:18 PM »
    Thinking a batch file that runs through the file as a CSV or TXT file could find all + and replace it with a space. Then you could open the CSV file with excel and have data delimited. Is this website open to all to look at so that we can see its structure to see what delimiter would be used etc? If its a website with content open to all without logon then please share link here so we can see data structure.

     Going to point this to the batch section here for a batch master to assist you with this. Please dont post this elsewhere.

    Not sure if a excel macro would be able to help you with this one.... Thinking conditioning the data first to remove the + signs prior to import to excel is the better way to go and import/open it as a CSV