Hi, I am new here and I need urgent help.

I have excel sheet with million rows, and I need macro which will, if cells in column A contains specific word or part of a word, for example just "Nick", then put letter "S" in column E in that same row.

Many thanks for helping me.