You cannot paste a table into a cell like you can in MS Word.
Nor can you paste text from HTML that has different fonts
attributes for different parts of the line (color, bold, italics) into Excel
like you can in MS Word.
In fact changing the font within parts of a cell can be rather
laborious in Excel. You have to do your selection from
the address bar not from the cell, and you can never have
multiple fonts/colors within a cell at same time unless it is
text (not a formula). I can't find my page but here is Dick's
http://www.dicks-blog.com/archives/2...l-in-cells-ii/
--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Tim" <tim j williams at gmail dot com wrote in message ...
Any code to show ?
If you paste into the cell *while in edit mode* it should all go into the
same cell.
Tim
"Bourgui" wrote in message
...
Hi experts,
I have this problem that's stalled me for a few days now: I want to pass
formatted text to an Excel cell. It sounds simple enough, but apparently
it
isn't.
The original text can be in RTF or HTML format. The closest I have come is
copying my data as HTML on the clipboard then pasting as HTML, however for
each line break the content gets sent to the next cell. I want to have it
all
in one cell.
Anybody has any idea? I don't need to use the clipboard, that's just
something that I thought might work...
Cheers!
Bourgui