simple excel logic
i am given a big excel sheet of FI transactional data, which has around 60 000 records,
the company codes have changed , previously which were 3000 are now 3050,
now there are a thousand records with comp code 3000, how do i change all these compcodes to 3050.
Naimesh Patel replied
But again it will take some time and you need to apply that formula to each row.
So, better to replace it.
Open your excel file..
Select the Entire columns(say column A) by clicking on the top .
Press Cntrl+F.. in the pop up select replace tab
Enter 3000 into Find what
Enter 3050 into replace with
Press button REPLACE ALL
It will take some time, but it will change all bukrs from 3000 to 3050