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!
Got a problem.
If you have an html document that's just a table, you can import it into Excel and get a spreadsheet. Of course, for each cell in the table you get a cell in Excel. But if there's a line break (<br> tag) within a cell, it screws up when you open the html document in Excel - it's like Excel treats the line break as a cell delimiter.
What we're doing is taking the result of an Access query and importing it into Excel. We first save from Access to an HTML document, because if you go straight from Access to Excel there's a 255 character limit for each cell.
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?
We're using Excel 2002 SP2.
eta: Alternatly, will Excell correctly deal with carriage returns in a delimited text file? (Assuming some other delimiter besides carriage return.)
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)
there is a 4 minute animation for the phone:
[link]
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.
