Hi,

I have an Excel table with i have to edit. The data in the table in very big and i need a code to replace some numbers.

I have a row called Old Number. In this row the account number is stored and looks like this "115000059001000"

I have to replace it with this format 100-2021

Table example.JPG

If you see the table in field A2 I have 115000059001000 and in field B2 I have 100-100.

The logistic I write was this:

fOR NUM=1 TO EMPTY.CELL

for I=2 to 327


if r(I)c1=r(I)c2 then r(I)c3=r(I)c3

NEXT I

NEXT NUM

Note that this code will do the same job as the Find and replace but I don't need to do a find and replace for every cell of the table.

Hope you understand.

Anticipated Thanks!!