View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.querydao
AhBook AhBook is offline
external usenet poster
 
Posts: 1
Default 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!