How to change find formula from single text field to more than one text field

Have excel code in a column with the following logic

Please Login or Register  to view this content.

Before all our bank merchant codes started with 576 now our merchant codes can start with 576 or 582. How can I change Find command in the above logic so Find looks for "DEPOSIT~~576" or "DEPOSIT~~582" and what do I do if bank makes further merchant code changes? Wherever you see 576 in above code we also have to include 582.

I inherited this Bank Reconciliation Spreadsheet so am trying to correct problems.

How would I modify this find command to search for more than one value? Please advise.

I changed the formula to the following instead of looking for 576 and 582. There is another field that identifies the transaction as coming from a POSTTECH transaction and all those transactions start with 582 or 576 so instead of looking for 576 or 582 I just look for transaction starting with DEPOSIT ***5

Please Login or Register  to view this content.