Good morning,
I have a downloaded file of bank transactions and in the description column, that contains a string of text and numbers, I want to be able to establish whether a customer reference, which could be numbers or text, is part of the description string.
So for instance:
The description on one line is:
<tbody>
</tbody>
If it is then I want to be able to categorise that transaction as being 'AR'.
I have tried to use INSTR but that only seems to work if you have a specific search criteria.
Any help would be appreciated.
I have a downloaded file of bank transactions and in the description column, that contains a string of text and numbers, I want to be able to establish whether a customer reference, which could be numbers or text, is part of the description string.
So for instance:
The description on one line is:
FRANCOTYP POSTALIA 503747 058027 DDR In my list of customers, the reference number for a customer is 058027 which matches the above string, so I want to return the value 'AR' in the cell to the right of the description column, which is column 'N' |
<tbody>
</tbody>
If it is then I want to be able to categorise that transaction as being 'AR'.
I have tried to use INSTR but that only seems to work if you have a specific search criteria.
Any help would be appreciated.