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.
As Willow goes, so goes my nation.
Oz ,'Selfless'
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!
tommyrot - Oct 04, 2005 11:52:33 am PDT #4756 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Sean K - Oct 04, 2005 12:16:32 pm PDT #4757 of 10003
You can't leave me to my own devices; my devices are Nap and Eat. -Zenkitty
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?
tommyrot - Oct 04, 2005 12:31:29 pm PDT #4758 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Is there anything in the help file about line break or formatting characters?
We couldn't find anything.
Sean K - Oct 04, 2005 12:32:29 pm PDT #4759 of 10003
You can't leave me to my own devices; my devices are Nap and Eat. -Zenkitty
BASTARDS!
Eddie - Oct 04, 2005 12:38:02 pm PDT #4760 of 10003
Your tag here.
Ok, a few posts up I got the html code that will recognize br tags when importing into Excel.
tommyrot - Oct 04, 2005 12:40:54 pm PDT #4761 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
Thanks, Eddie - we'll give that a try tomorrow.
tommyrot - Oct 04, 2005 12:54:58 pm PDT #4762 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
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.
Eddie - Oct 04, 2005 2:20:03 pm PDT #4763 of 10003
Your tag here.
Eddie - Oct 04, 2005 2:57:19 pm PDT #4764 of 10003
Your tag here.
tommyrot, have you tried exporting the query from Access as xml and then open that xml file in Excel? It seems to work for me, and I made a table with very long strings and line breaks and it came across cleanly.
Gris - Oct 04, 2005 5:23:34 pm PDT #4765 of 10003
Hey. New board.
Anybody know blink codes for Powermac G5s? i came home to my baby making the loud-fan noises that means something is wrong. Turned off, turned on... and nothing, mostly. It makes a fanny noise, but I don't get processor sounds, and the power light blinks three short blinks at me, repeatedly. Blink-blink-blink-pause. Blink-blink-blink-pause.
I don't have a non-wireless keyboard at this second, so I haven't been able to test if I can make it boot off of CD, yet.
Recently, the computer managed to kill a GB of RAM, and an attempt to reseat my secondary hard drive broke off the pin-alignment-device, so I'm kind of frustrated with it anyway. I may just wash my hands of it, and survive on my iBook until I can afford a powerbook.
If I decide to do that... anybody want a probably salvageable Dual-1.8 GHz powermac G5? I'll give it to you cheap, with nothing but a request for certain files burned to DVD and sent to me if you manage to get access to the hard drive. It... might even be under Applecare. When i'm feeling less lazy, I'll look up the serial number and check.