Paste web data to spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
(e-mail address removed)
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.
 
Back
Top