Split string into array - MrExcel.com | Excel Resources | Excel Seminars | Excel Product

Say I have a string, a test array. I want to split this into an array where each character is an element. I was thinking something like Code: Dim ... Sub TestIt() Dim a() As String Dim s As String s = "a test array" Call Split_String(a, s) Call TestOutput

www.mrexcel.com