Hi guys,

I have a long list of company names on an excel spreadsheet, around 122,000 records. Instead of individually going through each record, i wondered if there is a way to automate my request with a formula. Column D has the name of the company, and Column F will display a 0 if the company name includes the word/keyword 'broadband'. Do you guys know a quick way of doing this? Many thanks!

Jake