Paste web data to spreadsheet

[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.

 

[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
(e-mail address removed)

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.

 

[Ken]

Bingo! Never saw it till you mentioned it. Great Job and
many Thanks!

 

[Don Guillett]

glad to help