changing data

[Guest]

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?

 

[Guest]

Hi

Press <Ctrl><H> In the find box, type in the existing name, in the change
to box, type the new name, click on Change All, and its done