BYROW(...LAMBDA(...) ) result in #CALC! error

Hello,

As print screen below, I have some text (A1:A3) that I'd like to split.

The delimiter are ( , / ; | : ).

I was able to split it using FILTERXML and SUBSTITUTE (as shown in column E to K depending on the number of text). However, when I'd like it to be return the result dynamically both horizontally and vertically, I get #CALC! error.

Question now is how do I incorporate my dynamic array result horizontally down vertically based on the size of my data.

My working formula:

Please Login or Register  to view this content.

Not working formula:

Please Login or Register  to view this content.

SplitText Dynamically.png

ByRow can only spill down, not across.
How about

Formula:

Please Login or Register  to view this content.

SOLVED by Fluff13!

Tried to add reputation to you, but I can't as the last I gave was to you.

I had to give to others before I can give to you.

I owe you 1 reps up

Glad to help & thanks for the feedback.

Fluff13, finally, I'm able to give Reps up to you. Don't know if you're able to check and confirm.

Rep received many thanks.