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.
Willow ,'First Date'
Buffistechnology 2: You Made Her So She Growls?
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!
^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.
Otherwise, is there way to search an entire Excel document for a certain character (tilde, say) and replace it with a carriage return? In Word you can replace something with ^p for a paragraph (carriage return) or ^l (manual line break) but Excel does not work the same way.
I don't have a copy of excel at home, but I thought for sure there was a character combo that it would read as a line break or carriage return. Is there anything in the help file about line break or formatting characters?
Is there anything in the help file about line break or formatting characters?
We couldn't find anything.
BASTARDS!
Ok, a few posts up I got the html code that will recognize br tags when importing into Excel.
Thanks, Eddie - we'll give that a try tomorrow.
Eddie, that doesn't work for what we want to do. If we were to save your example as an html file and open it in Excel, we would want all the text to be in a single cell (because it's all in one <td>). But when I try that, it ends up in four cells (two of which are two cells high, so something is going on).
Anyway, I gotta run.