Split Function

One of the powerful functins of Excel VBA is Split function. Split function splits (parse) the string data with a given separator. For example, “Turkey/İzmir/Urla” string data can be splitted as follows:

Turkey

İzmir

Urla

Code required:

Dim StringParts() As String

StringParts  = Split( “Türkiye/İzmir/Urla” , "/" )

StringParts (0) = "Türkiye”

StringParts (1) = "İzmir"

StringParts (2) = "Urla"