VB/VBA String Processing
Printer Friendly Page
Mid (String, Start [, Length])
[Return a string of specified length from the designated starting point.
If length is omitted, the substring returned is from Start value to the end of the string.]
String . . . .
Name of the string to extract the substring.
Start . . . . .
Starting position to extract the substring.
Length . . . .
Length of the substring. If omitted the length to the end of the string is returned.
Right (String, Length)
[Return a substring for a designated number of characters from the right side of the string.]
String . . . .
Name of the string, or literal string.
Length . . . .
How many characters to return from the left of the string.
Left (String, Length)
[Return a number of characters from the left of the string.]
String . . . .
Name of the string, or a literal string
Length . . . .
How many characters to return from the left of the string.
InStr (Start, StringToSearch, StringToFind)
[Find the location of a string contained in another string.]
Start . . . . . . . . . . .
Starting position
StringToSearch . .
String being searched
StringToFind . . . .
String being searched for
If
(condition is true)
Then
(do this)
End If
If
(condition is true)
Then
(do this)
Else
(do this)
End If
[Return a substring for a designated number of characters from the right side of the string.]
String . . . .
Name of the string, or literal string.
Length . . . .
How many characters to return from the left of the string.