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

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

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