formula help

C

CJer

I have a plethora of spreadsheets that I would like to
alter by adding specific text to all cells immediately to
the right of a cell with specific text. Example: For all
cells that read University of Maine I would like to add a
cell to its right that has the text "Black Bears Main Gym".

How do I get excel to do this for me without me going
through, finding all desired cells and adding the new info
myself?

Please help ASAP. Much appreciated!
 
Top