All fields in column B contain the word "dairy"

Hello Excel Gurus,

I have a very simple question and I don't know the terminology to search for the answer.

I have a spreadsheet with 1800 records and I need to change all of the unique content in column B of each record to the word "dairy"

There must be a simple way. Can someone please give me a quick reply?

Thank you so much.

PPC

Hi Martin,

It was a unique 4 character code. A password of sorts. like "s2Uy"

I don't know what I did but I just opened the file again and all of the codes are now changed to "dairy"

Thank you very much for your attempt of kindness to a numberless graphic designer.

PCP