=LEFT(B52,(FIND("VOL",B52,1)-1))

This is my formula, i need to add additional words to VOL and need to work down the spreadsheet adding extra words.

How can this be done.