Forum Discussion

benross94's avatar
benross94
Copper Contributor
Apr 17, 2023
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. Ho...
excel
Formulas and Functions
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Apr 17, 2023

    benross94 

    =LET(
a,TEXTSPLIT(B2,,", "),
b,ISNUMBER(SEARCH("Truck",a)),
c,FILTER(a,b),
d,SUBSTITUTE(c," Crew",""),
TRANSPOSE(d))
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 17, 2023

benross94 

=LET(
a,TEXTSPLIT(B2,,", "),
b,ISNUMBER(SEARCH("Truck",a)),
c,FILTER(a,b),
d,SUBSTITUTE(c," Crew",""),
TRANSPOSE(d))
  • benross94's avatar
    benross94
    Copper Contributor
    Apr 17, 2023
    So fast. So good. So grateful thank you!

Resources