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
--
ve_2nd_at. Randburg, Gauteng, South Africa


"danzelindistress" wrote:

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?