need to split string(s)

[s4driver]

Looking for a code to use to split a string into 3 columns where the original data is all in 1 column and looks like this:

JPAJ-24-SG,TR-K,LR-BP
JTFT-1930-L,H-EC,HP-8J
PPD-18
QASS-36-BNS,TR-PLS
QBBK-2336-L,H-WL,HP-WL
3085-7007,TR-MC

after it's split looks like this:

Col 1
JPAJ
JTFT
PPD
QASS
QBBK
3085

Col 2
24
1930
18
36
2336
7007

Col 3
SG,TR-K,LR-BP
L,H-EC,HP-8J

BNS,TR-PLS
L,H-WL,HP-WL
TR-MC

basically need to find a way to split the string into three columns(if needed) based on the second "-" or if the "-" is a ","

thanks in advance, s4

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Probably better ways.

[s4driver]

this is what i have come up with:

Please Login or Register  to view this content.

I am struggling to get one line in my code to be dynamic

Please Login or Register  to view this content.

thinking I just need right syntax for the destination:=range(???)


any thoughts?