ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I assign delimiters to an excel web query? (https://www.excelbanter.com/excel-discussion-misc-queries/77731-how-can-i-assign-delimiters-excel-web-query.html)

Desperate Dan

How can I assign delimiters to an excel web query?
 
When performing a web query in excel, the data I need is all contained within
a single table. Consequently, when it's placed into my worksheet, it places
each line (each with differnt blocks of data separated by spaces) into a
single string. How can I get excel to recognize the spaces as delimiters and
place each item into separate cells?


All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com