simple excel logic

This question is answered

hi friends,

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.

thank you

Correct Answer

November 20, 2007 at 20:17 PM

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

Regards,

Naimesh Patel

0 Likes 0 View this answer in context