Forum Discussion

benross94's avatar
benross94
Copper Contributor
Apr 17, 2023

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...
  • Detlef_Lewin's avatar
    Apr 17, 2023

    benross94 

    =LET(
    a,TEXTSPLIT(B2,,", "),
    b,ISNUMBER(SEARCH("Truck",a)),
    c,FILTER(a,b),
    d,SUBSTITUTE(c," Crew",""),
    TRANSPOSE(d))

Resources