Be the first user to complete this post
|
Add to List |
VBA-Excel: Array Functions – Split()
Description:
Split() Function returns one dimensional array containing the substrings, after splitting the main string based upon the delimiter provided.
Format:
Split(strMainString [, delimiter[,intlimit[, vbCompare]]])
Arguments:
- strMainString
- Mandatory
- Type: String
- String which will be split
- delimiter
- Optional
- Type: Any
- The expression based on which the strMainString will get split
- intLimit
- Optional
- Type : Numeric
- No of substring to be returned.
- Compare
- Optional
- Type: Numeric
- The type of comparison to find the string in the main string, like vbBinaryCompare ( Value =0), vbTextCompare (value=1).
Example :
Function FnSplit() Dim strMainString Dim strTemp strMainString = "This is Split Function Example" arrSplit = Split(strMainString, " ") For i = 0 To UBound(arrSplit) strTemp = strTemp & arrSplit(i) & " " & vbCrLf Next MsgBox strTemp End Function
Also Read:
- VBA Excel - Cells, Ranges and Offset: Refer to Cells by Using Shortcut Notation
- VBA-Excel: Date-Time Functions – Day()
- VBA-Excel: String Functions – Mid()
- VBA-Excel: Arrays – Two Dimensional, Static Array
- VBA-Excel: Arrays – One Dimension, Dynamic Array