Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
Pivot and changing External data source | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |