Saturday, September 1, 2007

Text Manipulation

I received many queries regarding text manipulation. Here are some useful text functions which you could use to EDIT your text.

Sub myEdit()
MsgBox Left("abcd", 2) 'Displays 2 characters from Left
MsgBox Right("abcd", 2) 'Displays 2 characters from Right
MsgBox Len("abcd") 'Displays number of characters
End Sub

No comments:

Post a Comment