if you had "bob killed mary ott", find everything to the left of " killed"?
Printable View
if you had "bob killed mary ott", find everything to the left of " killed"?
Code:TxtFound=Left("bob killed mary ott",Instr(1,"bob killed mary ott","killed")-1)