Please forgive me if this is a duplicate post. I wasn't sure what to search for to see if this has been answered in the past.

I have a spreadsheet that contains contact information and website URL for several thousand contractor companies. Header columns are: (A through I) "Company Name, Address, City, State, Zip Code, Phone, Email, and Website" I inserted a new blank column before "Company Name" and called it "Category" I would like to be able to categorize each company by the type of service that it provides.

I would like to learn how to code a Conditional Format Rule or function that would add text to column "A" cells if the company name (Column B) contains text that I specify.

Example: If Company Name in cell B1 contains "Roofing", then "Roofing" would be inserted into cell A1 in the "Category" column. Or if cell B457 contains "plumb" (partial match for plumber), then "Plumber" would be inserted in to A457.

Any assistance with this will be greatly appreciated.

Thanks in advance,

Jack