I'm using the following function (I'm displaying the guts of it only) to
convert a datatable to an excel spreadsheet:

For Each mrow In dt.Rows
rowindex += 1

colindex = 0

For Each col In dt.Columns

colindex += 1

objws.Cells(rowindex, colindex) = mrow(col.ColumnName).ToString()

Next

Next

It works fine; however, when I convert columns with carriage returns in
them, the row does not wrap inside Excel; instead, you end up with a very
long (verticle) column. Inside Excel, even columns/autofit selection has
not effect. The entire spreadsheet, therefore, looks distorted. Is there
any way to strip out chr(10) + chr(13) from the data?

Thanks for any help.

Bernie Yaeger

Hi Bernie,

When you look down about 20 rows in this newgroup you see a question from
Able almost like this,

I found it funny because a lot of people where answering on that.

Armin gives as extra the answer you need complete. (with the vbcrlf)
(I would take that one, mine was just a completely alternative method from
the earlier posters and I posted the same time as Armin)

If you cannot find it, I can give you of course the answer, but there are so
much possibilities in this message and answers.

By the way, if it is than still not working have than also a look at the
"HT" "09" and "Lf" "13" because as far as I remember me, Cindy once told in
this newsgroup that that was used with Excel.

I hope this works.

Cor

Hi Cor,

I've looked 60 down and in different sort orders but can find no other
question like mine. Can you give me some more info on that message?

Tx,

Bernie

"Cor" <(E-Mail Removed)> wrote in message
news:ekIHEsF%(E-Mail Removed)...
> Hi Bernie,
>
> When you look down about 20 rows in this newgroup you see a question from
> Able almost like this,
>
> I found it funny because a lot of people where answering on that.
>
> Armin gives as extra the answer you need complete. (with the vbcrlf)
> (I would take that one, mine was just a completely alternative method from
> the earlier posters and I posted the same time as Armin)
>
> If you cannot find it, I can give you of course the answer, but there are
so
> much possibilities in this message and answers.
>
> By the way, if it is than still not working have than also a look at the
> "HT" "09" and "Lf" "13" because as far as I remember me, Cindy once told
in
> this newsgroup that that was used with Excel.
>
> I hope this works.
>
> Cor
>
>

Hi Bernie,

Here is the link on Google, saves time

http://www.google.com/groups?selm=fvmZb.5318$(E-Mail Removed)

If it is not what you ment, tell me, but I am almost sure of it.

Cor

Hi Cor,

Yes, that is exactly what I needed! Tx.

Bernie

"Cor" <(E-Mail Removed)> wrote in message
news:eu08pBJ%(E-Mail Removed)...
> Hi Bernie,
>
> Here is the link on Google, saves time
>
> http://www.google.com/groups?selm=fvmZb.5318$(E-Mail Removed)
>
> If it is not what you ment, tell me, but I am almost sure of it.
>
> Cor
>
>