VBA-Excel: Array Functions – Split()

Descrip­tion:  Split() Func­tion returns one dimen­sional array con­tain­ing the sub­strings, after split­ting the main string based upon the delim­iter pro­vided. For­mat: Split(str­Main­String [, delimiter[,intlimit[, vbCom­pare]]]) Argu­ments: str­Main­String Manda­tory Type: String String which will be split