LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.querydao
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
line break does not appear in CSV BFON Excel Discussion (Misc queries) 3 April 29th 10 04:23 PM
Possible to add a Line break in a formula ? Ricardo the Numpty Excel Discussion (Misc queries) 2 February 13th 08 11:06 AM
Line break GARY Excel Discussion (Misc queries) 1 November 6th 07 12:00 AM
Break cell into multiple lines by line break Chia Excel Discussion (Misc queries) 1 August 20th 06 06:37 AM
Line Break Ramthebuffs Excel Discussion (Misc queries) 4 August 22nd 05 08:52 PM


All times are GMT +1. The time now is 08:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"