Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to paste multiline HTML into a single cell in Excel 2003?
I have some source HTML code that I need to put in a single cell in Excel
2003 for testing purposes. I've tried pasting special with all options, no luck. I saved the code snippet to a .txt file first (to strip formatting) and it still wants to paste across multiple rows (due to end-of-line symbols, I'm guessing). I even tried assigning the source to the target cell in VBA, but there are already lots of quotes in the HTML, plus I don't want to mess up the end-of-line characters (it is part of what I need to test) so that was unsuccessful as well. Is there any (relatively easy) way to paste a block of HTML source into a single cell? I don't care if the new lines are seperated (like what you would get by entering [alt-enter] in a cell, or if it all runs on together in one long wrapped line, as long as the original html source is "intact" for accurate testing. Thanks for any advice, Keith |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to paste multiline HTML into a single cell in Excel 2003?
Try pasting into the formulabar.
Ker_01 wrote: I have some source HTML code that I need to put in a single cell in Excel 2003 for testing purposes. I've tried pasting special with all options, no luck. I saved the code snippet to a .txt file first (to strip formatting) and it still wants to paste across multiple rows (due to end-of-line symbols, I'm guessing). I even tried assigning the source to the target cell in VBA, but there are already lots of quotes in the HTML, plus I don't want to mess up the end-of-line characters (it is part of what I need to test) so that was unsuccessful as well. Is there any (relatively easy) way to paste a block of HTML source into a single cell? I don't care if the new lines are seperated (like what you would get by entering [alt-enter] in a cell, or if it all runs on together in one long wrapped line, as long as the original html source is "intact" for accurate testing. Thanks for any advice, Keith -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to paste multiline HTML into a single cell in Excel 2003?
Thanks Dave! That worked perfectly. Now I'm going to go sulk for having
wasted so much time and completely missing such a simple solution... <g Thanks again, Keith "Dave Peterson" wrote in message ... Try pasting into the formulabar. Ker_01 wrote: I have some source HTML code that I need to put in a single cell in Excel 2003 for testing purposes. I've tried pasting special with all options, no luck. I saved the code snippet to a .txt file first (to strip formatting) and it still wants to paste across multiple rows (due to end-of-line symbols, I'm guessing). I even tried assigning the source to the target cell in VBA, but there are already lots of quotes in the HTML, plus I don't want to mess up the end-of-line characters (it is part of what I need to test) so that was unsuccessful as well. Is there any (relatively easy) way to paste a block of HTML source into a single cell? I don't care if the new lines are seperated (like what you would get by entering [alt-enter] in a cell, or if it all runs on together in one long wrapped line, as long as the original html source is "intact" for accurate testing. Thanks for any advice, Keith -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from processing HTML? IE paste raw html. | Excel Discussion (Misc queries) | |||
Pasting HTML into a single cell | Excel Discussion (Misc queries) | |||
Can Web Query retrieve a single HTML table cell? | Excel Discussion (Misc queries) | |||
Excel 2003 SP2 hangs on HTML paste | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |