String1 ="ABC DEF GHI JKL MNO PQR STU VWX YZ"
Result = Split(String1, " ")
For Each String in Result
  MsgBox Result
Next
 
String2 = "123|456|789|101112|131415|161718
Result2 = Split(String2, "|")
For Each Number in Result2
  MsgBox Number
Next