We have 45 branch locations at our company. Each location is assigned a
merchant number to use when processing credit cards from customers. Our month
end bank statement is around 1000 lines long and lists all of our branches
sales paid for by credit card using their merchant number as an identifer. I
would like a formula that reads down the bank stmt and replaces each merchant
number with our branch number, so I can balance the bank for each branch. For
example if the merchant number attached to branch 1 is 500263 (this never
changes) I would like the formula &/or function to locate every instance of
that merchant number 500263 in the bank statement (it's on excel) and replace
it with our branch number 1 and so on. I have used the,edit- find- replace
all, but this is tedious. Please help!