Len() Returns the number of characters in a string. : String Function « Data Type « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
VBA / Excel / Access / Word » Data Type » String Function 




Len() Returns the number of characters in a string.
 
Sub strDemo9()
   Debug.Print Len("Test")
End Sub

 
Related examples in the same category
1.Format() Formats strings, dates, and numbers as specified.
2.InStrRev begins searching at the end of a string and returns the position where one string is found within another string:
3.Instr function returns the position where one string begins within another string
4.Left(string, length) returns the specified number of characters from the left end of a string
5.Right(string, length) returns a specified number of characters from the right end of a string
6.Mid(string, start[, length]) returns the specified number of characters from inside the given string
7.UCase returns a string that is all uppercase
8.InStr() Returns the location of the first character of a substring within another string.
9.InStr(): A number representing the place value of a particular character within a string
10.Using LTrim, RTrim, and Trim to Trim Spaces from a String
11.Len() return the number of characters in a string
12.LCase() Converts the string to lowercase.
13.UCase() Converts the string to uppercase.
14.StrReverse() Reverses the order of the characters in a string.
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.