jeudi 22 juin 2006 08:03I 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 ?
Toutes les réponses
jeudi 22 juin 2006 08:29ModérateurI believe Alt+Enter in Excel is not Chr(13)+Chr(10). I think it is only Chr(10) = vbLf.
jeudi 29 juin 2006 03:03Oh i know that but i tryed but can't get return of excel
jeudi 29 juin 2006 06:41ModérateurI'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?
vendredi 1 juin 2007 15:29
I cant use CHAR (10) to get a new line within a cell?
Can anyone help me here?
vendredi 1 juin 2007 16:44ModérateurNo, you can't. Did you read the entire thread carefully?
vendredi 9 novembre 2007 01:03
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?
vendredi 9 novembre 2007 08:18Modérateur
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:
jeudi 29 avril 2010 22:56I 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.
- Proposé comme réponse Jonathan Skarda mercredi 21 juillet 2010 22:13
mercredi 3 août 2011 03:13
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!
vendredi 8 juin 2012 09:19Thank you. You saved my day. :-)
mardi 23 octobre 2012 17:41Thank you! THis saved my day too! Appreciate the response.