Find text within CSV string, but order varies

Hi there,

I’m looking for help extracting portions of CSV text within a long array, but the order within varies. For example…

Record 1 Array:
Text01,Text-style02,Text-variation03

Record 2 Array:
Text-syle02,Text-type04

Record 3 Array:
Text-type04

Could someone point me towards a FIND formula that will display just one of each of these in a unique field, please? And ideally the start info is trimmed off, too. Resulting data…

Record__Text___Text-style___Text-variation___Text-type
1_______01____02________ 03____________________
2_____________02_______________________04_____
3______________________________________04_____

I’ve been going round the houses trying to find a solution, any help very much appreciated.

Thanks all.