solved here
https://www.mrexcel.com/board/thread...2#post-5908551...
Hi thank you, I've tried this, but then it said function is invalid...
https://prnt.sc/6zb8AGKPClBe
My ms excel version...
Thank you, but I am looking for a formula that will do what the wizard does. Splitting needs to be done as items are selected....
Elso Today, 01:28 AMIn cell B2 of Sheet1:
=TEXTJOIN(",",TRUE,FILTER(Sheet2!$A$2:$A$4,ISNUMBER(SEARCH(" " & TRIM(A2) & " "," "
Please assist with a split text to columns formula
And here: https://www.excelforum.com/excel-gen...el-2013-a.html...
AliGW Today, 10:26 PM