Posts Tagged ‘VBA’

As there is no split function in excel, you can create a UDF to gain the same functionality as available in languages such as Java, PHP, etc Create a module and add a function as below: Function STR_SPLIT(str, sep, n) As String Dim V() As String V = Split(str, sep) STR_SPLIT = V(n – 1) […]

Mar 16th, 2016 | Filed under Windoze