24 Ekim 2019 Perşembe

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"

Hiç yorum yok:

Yorum Gönder