Web Query Import to a single cell

**IBM400** · 01-15-2008, 07:33 PM

I am trying to import web data into single cell. However the data on the website is formatted and it keeps inserting columns. I have tried various formatting options but to no avail. Any ideas?
For example, I have this data and it goes into three colums. I would like it in one cell.

Date Action Location
9/10/2007 LFA/bill assigned to staff for fiscal analysis LRGC
10/2/2007 LFA/bill sent to agencies for fiscal input LRGC
10/23/2007 LFA/fiscal note sent to sponsor LRGC

**SuitedAces** · 01-15-2008, 07:58 PM

There are more refined ways to do this , but for the sake of simplicity ,why don't import onto a seperate worksheet or range.
Then modify the macro to concatenate and write the value(s) to the desired range.