How to get char(13)&char(10) in Excel ?

Question

I got string in excel to covert HTML by VB.NET but when i got a string with alt-enter(enter row in excel) i used this code
str = str.Replace(vbcrlf,"<br>")
to replace any crlf in string in excel but this code not work.
Anyone help me ?

Answer 1

I believe Alt+Enter in Excel is not Chr(13)+Chr(10). I think it is only Chr(10) = vbLf.

Answer 2

Oh i know that but i tryed but can't get return of excel
thats problem!!!

Answer 3

I'm sorry, I don't understand. In your original question you showed you're trying to substitute <br> for vbCrLf. I tell you Excel does not use vbCrLf, it uses vbLf. In what manner does this not work?

Answer 4

Hi,

 

I cant use CHAR (10) to get a new line within a cell?

 

Can anyone help me here?

 

Thank you.

 

Bernard

Answer 5

No, you can't. Did you read the entire thread carefully?

Answer 6

 

The Alt+Enter works fine for text entries in a field. However, when you use the concatenate function, we get an unrecognized character symbol, instead of the carriage return.

 

What does it take to get a carriage return concatenated between 2 strings?

Answer 7

For help on how to use functions in Excel, and other questions related to using Excel as an end-user, you should go to the newsgroup interface. This forum is specifically targeted at the Visual Studio .NET developer technology VSTO. Here's the newsgroup for Excel functions:

 

http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.excel.worksheet.functions&lang=en&cr=US

Answer 8

I realise this answer is years late, but the issue here is that for the CHAR(10) to function, the cell has to have "Wrap text" enabled.

Answer 9

I realise this answer is years late, but the issue here is that for the CHAR(10) to function, the cell has to have "Wrap text" enabled.

Thank you :-) save me the minutes of reading indirect responses in this thread!

Answer 10

Thank you. You saved my day. :-)

Answer 11

Thank you! THis saved my day too! Appreciate the response.