Typing line-broken text into Excel cells 1

[travisbrown]

I need to get some text with line breaks into Excel cells. I can't use return or shift-return. How would one go about this? Use a Wordpad OLE as a control?

Any hints?

 

[SkipVought]

Hi,

Please state your business case for this requirement.

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[PeterMoran]

Hi,

Give Alt+Enter a try!

Peter Moran

 

[travisbrown]

My business case? I'm modifying an ASP application that uses an Excel file as a datasource. There's a requirement to deliver some additional content that is paragraphic text.

Sure, Excel isn't the best thing for the type of data, but it's what I've got to work with.

 

[travisbrown]

Hi,

Give Alt+Enter a try!

Peter Moran "

Excellent. Thanks.

 

[travisbrown]

But... is there a way to use a Wordpad OLE to populate a cell?