data extract in column, formula, split into various columns

[dude6571]

Hi,

Today, my challenge is to find a XL formula or M code function (Power Query) to split data from 1 column to 3 columns.

I 've tried to split column with delimiter in Power Query but cannot find the right outcome.

Any help would be highly appreciated.

dude6571

[Bo_Ry]

Please try at D3
=IFERROR(-LOOKUP(0,-RIGHT(SUBSTITUTE(SUBSTITUTE(LEFT($B3,SEARCH(D$2,$B3)-1),"mē",),"ar.",),{1,2,3,4,5,6,7,8})),"")