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: Array Functions – Join() – Converts Array to String
- VBA Excel - Cells, Ranges and Offset : Offset
- VBA-Excel: Date-Time Functions – DatePart()
- VBA-Excel: String Functions – Space()
- VBA-Excel: String Functions – strComp()