Web Query and Line Break <BR tags
Hi there,
I have a problem that I have seen come up a few times in searching
through the archives, but I have not been able to find a solution (if
there is one).
I have a project that I believe an Excel Web Query would be perfect
for, except for one small problem.
When I run a Web Query against a website to pull in a table, and in
that table one of the cells has multiple lines separated by <BR tags,
Excel puts the multiple lines into separate cells.
The ideal situation would be for it to use the <td tags as cell
delimiters, not the <br tags.
Can anyone think of any clever workarounds to this?
Thanks!
|