Please can someone tell me how to do an automatic change all the way down a
column.

For example,

i have a list of applications throughout a spreasheet as follows

Approach, Eurosys, Oscar, Pivot_Pro
Pivot_Pro, Oscar, Approach,

i need to change exery occurance of Pivot_Pro to Pivot (Dual)

how will i do this

please help?