remove spaces from the front and back?

[Whatupdoc]

how do i remove the spaces from this string: " Hello World "

i want to change that string to "Hello World"

so i just want to remove the space from the front and back, anyone know an easy way to do this?

[vbasicgirl]

use the Trim() function

yourstring = Trim$(yourstring)

casey.

[penagate]

If you need you can also use the LTrim$() and RTrim$() functions to remove whitespace from the left edge only and right edge only, respectively.

[JensPeder]

Text1.text = Trim$(Text1.text) - Will this work on a multilined textbox? Or whats the best way of doing that?

(not at home atm, so I can't test )

[penagate]

It removes all whitespace from the left and right of a string.

If you want to apply it to all lines,

Dim lines() As String, i As Long
lines = Split(Text1.Text, vbNewLine)
For i = 0 To UBound(lines)
    lines(i) = Trim$(lines(i))
Next i
Text1.Text = Join(lines, vbNewLine)

[JensPeder]

Ah, I made my own code, but its slow

Thanks man, I'll test it later