I ended up using the below to extract left of several possible words. Is there an easier way to do this?
=IFERROR(IF(A331<>"",LEFT(A331,SEARCH("Every",A331)-1),""),IFERROR(IF(A331<>"",LEFT(A331,SEARCH("On",A331)-1),""),IFERROR(IF(A331<>"",LEFT(A331,SEARCH("Rental",A331)-1),""),IFERROR(IF(A331<>"",LEFT(A331,SEARCH("Move",A331)-1),""),IFERROR(IF(A331<>"",LEFT(A331,SEARCH("One",A331)-1),""),IFERROR(IF(A331<>"",LEFT(A331,SEARCH("Weekly",A331)-1),""),IFERROR(IF(A331<>"",LEFT(A331,SEARCH("Biweekly",A331)-1),""),"")))))))
Bookmarks