File sample 1 (the file I will merge) . As you can see when on column i when you click the 0 it shows the formula
When I merge that into 1 excel file the formula should not be remove and should still be the same like what you can see above.
I want to merge this 2 files into 1 excel including the formula. Any idea thanks.