Substring-esque function

[Raman325]

Hi, I am trying to create a function that, when given a string, can
return a substring from this string. The strings I will be passing to
the function are formatted as following: "text to return Procedure
extra garbage." Basically, the only word that I know will be in there
for sure is Procedure, and I want to return everything before that,
regardless of what's after it. Is this possible, and if so, how? Thanks
in advance for your help and I apologize if this is a dumb question.

-Raman

 

[Guest]

=LEFT( A1, SEARCH("Procedure", A1)-1)

Where your target string is in cell A1

 

[Raman325]

Great, thanks a lot