PDA

View Full Version : finding the wordwarp charactere ?



DarkRider950
01-29-2008, 12:36 PM
Hi, I try to find a way to replace the word warp character by "alt-enter"

in my excel page a got a textbox with word warp =true and multi line = true but the text is imported into SQL server and it do not like the word warp thing.

First I do not see the word warp character... anyway to find it ?
or any other solution . :banghead:

Thank in advance.

Bob Phillips
01-29-2008, 12:53 PM
There is no word-wrap character, it is all managed by Excel as a presntational function. If you widen a cell, you will see the wrap change.

DarkRider950
01-29-2008, 01:04 PM
any other solution to put "alt-enter" after 50 charactere ?:dunno

Bob Phillips
01-29-2008, 02:11 PM
Yeah, that is simple



With ActiveCell

.Value = Left$(.Value, 50) & Chr(10) & Right$(Len(.Value) - 50)
End With