Paste web data to spreadsheet

K

Ken

I am able to paste large spreadsheet like data from the web onto excel by using the New Web Query, however, it all gets pasted to A1. Am I able to somehow seperate each column like how it would appear in the original. My goal is to be able to sort/filter this information.
 
D

Don Guillett

Give me/us some info such as the url and what you want to do and we will
help.
In the meantime, try using Data>text to columns

--
Don Guillett
SalesAid Software
[email protected]
Ken said:
I am able to paste large spreadsheet like data from the web onto excel by
Click to expand...
using the New Web Query, however, it all gets pasted to A1. Am I able to
somehow seperate each column like how it would appear in the original. My
goal is to be able to sort/filter this information.
 
Top