delete a cell if

delete a cell if it contains a spefic word, and shift the row left? i need
the programe to do this automatically? and not to have to do it manually, as
there are 57,000 lines on the sheet, and about 5000 will need to be deleted.

HELP!!