Forum Discussion
benross94
Apr 17, 2023Copper Contributor
Pulling one or more words from string of text
Referring to the document linked here, 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, eve...
- Apr 17, 2023
=LET( a,TEXTSPLIT(B2,,", "), b,ISNUMBER(SEARCH("Truck",a)), c,FILTER(a,b), d,SUBSTITUTE(c," Crew",""), TRANSPOSE(d))
Detlef_Lewin
Apr 17, 2023Silver Contributor
=LET(
a,TEXTSPLIT(B2,,", "),
b,ISNUMBER(SEARCH("Truck",a)),
c,FILTER(a,b),
d,SUBSTITUTE(c," Crew",""),
TRANSPOSE(d))
benross94
Apr 17, 2023Copper Contributor
So fast. So good. So grateful thank you!