Be the first user to complete this post
|
Add to List |
VBA-Excel: String Functions – String()
Description:
The String() function returns a string consisting a repeating characters of specified length.
Format:
String(number,character)
Arguments:
- number
- Mandatory
- Type: Numeric
- No of times the character to be repeated, means length of the returned string.
- Character
- Mandatory
- Type: Numeric
- Character to be repeated
Function FnString() intNumber = 10 strChar = "S" MsgBox String(intNumber, strChar) End Function
Also Read About Other String() Functions
INSTR() | InstrREV() | LCase()
Also Read:
- VBA-Excel: Delete Blank Rows from Excel Work Sheet
- VBA-Excel : Strings Functions – Left
- VBA-Excel: Date-Time Functions – CDate()
- VBA-Excel: Array Functions – Split()
- VBA-Excel: Date-Time Functions – FormatDateTime()