I have a program that generates weather maps based on data inside of an excel spreadsheet. There are weather servers you can submit queries to in the form of html links that will give you whatever information you need. Example: http://nomads.ncep.noaa.gov:9090/dods/gfs/gfs20110322/gfs_12z.ascii?tmp2m[1:1][128:128][283:283] (current temp in baltimore, md).
When I import this into excel, it combines the second line in one cell. I can manually separate them from there, but one of the features excel has is automatic refreshing which would be helpful for what I need. Does anyone know of a way to separate the line into two cells and still have it be automatically refreshed?
When I import this into excel, it combines the second line in one cell. I can manually separate them from there, but one of the features excel has is automatic refreshing which would be helpful for what I need. Does anyone know of a way to separate the line into two cells and still have it be automatically refreshed?