ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   changing data (https://www.excelbanter.com/excel-discussion-misc-queries/36392-changing-data.html)

danzelindistress

changing data
 
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?

Kassie

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?



All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com