Be the first user to complete this post
|
Add to List |
VBA-Excel: String Functions – Len()
Description:
The Len function returns the number of characters in a string including spaces.
Format:
Len (strMainString)
Arguments:
- strMainString
- Mandatory
- Type: String
- String who’s both number of characters to be returned.
Function FnLen() Dim strMainString strMainString = " Sumit Jain " MsgBox "No of characters (including spaces) are” & Len(strMainString) End Function

Also Read About Other String() Functions
INSTR() | InstrREV() | LCase()
Also Read:
- VBA-Excel: Select and Activate Cells - Select
- VBA Excel – Refer to Multiple Ranges : Union Method
- VBA-Excel : Strings Functions – Left
- VBA-Excel: String Functions – Replace()
- VBA-Excel: String Functions – Space()