splitting an array

[newbie777]

Hello everyone,

I have an array that has 100 values. The values are text1 & "|" & text2.

I need to split this array into two columns. Text 1 in column X and text2 in column Y.

I failed to do it. Can you please help?

Thanks!

 

[newbie777]

It works now! Many thanks..

I just modified your declaration!

Thanks again