jag har en sträng som ser ut såhär:
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

hur gör jag om jag vill ha den såhär:

xxxxxxxxxxxx" & VbCrlf & " xxxxxxxxxxxx" & VbCrlf & "xxxxxxxxxxxx" & VbCrlf

?

Såhär kanske:

<code>
str = "abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij"
If Len(str) > 50 Then
strTmp = str
str = ""
While Len(strTmp) > 50
str = str & Left(strTmp, 50) & vbCrLf
strTmp = Right(strTmp, Len(strTmp) - 50)
Wend
str = str & strTmp
End If
</code>

/Johan