Im trying to write a formula were i can get the programe to check the file
and if a cell contains 'agency' i want it to delete the cell and shift it
left. the reason for the formula is that the file will be in a differnt
order/size each time, and cannot just do this manually.

Thanks