Computer Hope
Microsoft => Microsoft Windows => Windows 10 and 11 => Topic started by: slambos2500 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 ??
-
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