How to search a row for a particular word and add a value of 1 each time

Hi there,
I have a rather basic question that I'm hoping someone may be able to assist with.
I have a column that contains the word "Trigger" repeatedly (the word appears every 10-15 or so rows). I want to add a number immediately after each of these "Trigger" labels so that the label increases by a value of 1 each time (e.g. Trigger1, Trigger2, Trigger3 etc. etc. all the way up to Trigger900).
Presumably this is a fairly easy thing to do, but I'm a novice when it comes to Excel!
Any help greatly appreciated.

Thanks special-K, this has worked nicely!