Extracting the bank account number
If you want to take part of the text contained in a cell and reuse it elsewhere, you can extract part of the text.
The HRMS Export preparation contains French International Bank Account Numbers (IBAN). An IBAN is a 33-characters code, including spaces. It is made of a Country code, two check digits, a five-digit bank identifier, a five-digit branch identifier, an eleven-digit account number, and two final check digits.
You will extract the account number part of those IBAN, to a new column.
Before you begin
It is recommended to remove unnecessary blank spaces from the text records and to make sure the cells have the same length before proceeding.
Procedure
-
Configure the function as follows:
The selection will start at the 17th character, spaces included, and end two characters before the end.
Results
The text corresponding to the selection you made is extracted to a new column, that you can rename if you want.