Fred ,'A Hole in the World'
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
So, is there some other character we can insert into the html (doesn't matter if it does not produce a line break in html) that will produce a line break when opened in Excel?
Not even remotely sure this will work, but can't you do a find/replace on your HTML doc to replace all instances of t br with a ^M?
(ETA: Not entirely sure Excel will read a ^M as a carriage return, but I think it might)
Lemme try....
Jessica,
that's a hot phone. Man.
Nah, it ain't ^M. I'm searching for some other character that Excel will see as a new line....
^l should give you a line break
there is a 4 minute animation for the phone
I didn't realize you could make the phone automatically change shape when a call comes in or an alarm goes off. Wacky!
Well, once they create the "liquid battery, speech recognition, flexible touch screen, [and] touch sensitive body cover," why not make it change shape? The world is your oyster.
^l should give you a line break
Nope. At least it doesn't when in an html file being opened in Excel.
tommyrot, this will do what you're asking for:
<html>
<head>
<style>
<!--table
br
{mso-data-placement:same-cell;}
.xl24
{mso-style-parent:style0;white-space:normal;}
-->
</style>
</head>
<table>
<tr>
<td class=xl24>adsf<br><br>asdfasdf<br><br><br>asdf</td>
</tr>
</table>
</html>
I got this from saving an Excel file as htm and then reducing Microsoft's craptacular html code to just these essentials to get it to respect the br tags.