Forum Discussion
Solved
Pulling one or more words from string of text
Referring to the document linked https://1drv.ms/x/s!AsAcHcm1UiD3exbJc-Dd6juh2to?e=uhD7y6, you will see in column D, there is a formula successfully pulling which Truck # is mentioned in column B. However, it stops after the first Truck mentioned, even though sometimes there may be multiple Truck #s (row 7 for example). Can someone please tell me what formula I would need to have all Truck #s pulled out in separate cells?
=LET( a,TEXTSPLIT(B2,,", "), b,ISNUMBER(SEARCH("Truck",a)), c,FILTER(a,b), d,SUBSTITUTE(c," Crew",""), TRANSPOSE(d))
2 Replies
=LET( a,TEXTSPLIT(B2,,", "), b,ISNUMBER(SEARCH("Truck",a)), c,FILTER(a,b), d,SUBSTITUTE(c," Crew",""), TRANSPOSE(d))- So fast. So good. So grateful thank you!
