Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

simple excel logic

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

Tags:
Former Member
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

Regards,

Naimesh Patel

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question