How to split a comma separated arraylist into separate arrays

[WednesdayC]

Hi All

Can anyone help me please?

I have a long arraylist (AL). Each item contains 4 words separated by commas i.e "Test1", "Test2", "Test3", "Test4" is one item.

I would now like to have 4 more arraylists, containing the First, Second, Third and Fourth words respectively.

I have tried to use the split function, but just can't work it out

Also, I can sort by the first word of (comma separated) AL, but how do I then sort by second, third and fourth word of AL.

Thank you in advance.

Wednesday

 

[CharlesChuckieCharles]

ON the Data tab in excel you'll find the "text to columns" function
sounds like what you need

 

[WednesdayC]

Hi CharlesChuckieCharles

This is a programme I have written

I meant I need some macro help for this.

I should have said

Regards
Wednesday