how do I trim the first character from the left?
Printable View
how do I trim the first character from the left?
Do you mean removing the first character from the left?
yes
Code:Text1.Text = Right(Text1.Text, Len(Text1.Text) - 1)
Will display "ello" in the debug window.Code:Dim Text As String
Text = "Hello"
Text = Right(Text,Len(Text)-1)
Debug.Print Text
Sorry Dennis, I didn't read your post.
thanks to both
text = mid(text,2) will remove the first char from the left
thanks