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"
