Sulprobil
Search…
sbSplit
Former function name was WSSplit
Excel lacks a worksheet function split which can split a cell content onto several cells with a given delimiter.
The user defined function sbSplit below solves this.
sbSplit implements the VBA split function as described here:
Please read my Disclaimer.
1
Function sbSplit(sExpression As String, _
2
Optional sDelimiter As String = " ", _
3
Optional iLimit As Integer = -1, _
4
Optional iCompare As Integer) As Variant
5
'Source: https://berndplumhoff.gitbook.io/sulprobil/excel/excel-vba-solutions/sbsplit
6
'V0.2 21-Oct-2020
7
'Implements the VBA split function as described here:
8
'https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/split-function
9
sbSplit = Split(sExpression, sDelimiter, iLimit, iCompare)
10
End Function
Copied!
sbSplit.xlsm
31KB
Binary
Last modified 1yr ago
Copy link