Snasui Excel Forum

Posted: **Thu Jul 25, 2024 5:00 pm**

Hi there

Please solve this to split text

thanks

Posted: **Thu Jul 25, 2024 7:58 pm**

...

D2

=HSTACK(INDEX(A1:A4,TOCOL(ROW(B2:B4)/(MAP(B2:B4,LAMBDA(x,LEN(x)-LEN(SUBSTITUTE(x,",",""))+1))>=COLUMN(A1:Z1)),2)),TEXTSPLIT(TEXTJOIN(",",1,B2:B4),1,","))

Bigcat9
BKK Thailand

Posted: **Fri Jul 26, 2024 9:58 am**

thanks so much

Snasui Excel Forum

text split

text split

Re: text split

Re: text split