Hello,
I would need to find if any string in column T contains the word "FEES" and if so, extract the preceding word plus FEES in the adjacent column.
Example, description in T1:
Result in cell U1:
MGT FEES
If "MGT FEES Q2 2023" was possible that would be even better.
NB, The string FEES can appear anywhere in the description and the length of it is variable.
Example 2:
The expected result here should be:
VAT FEES
or
even better, VAT FEES 2022
Appreciate any suggestions, thank you!
I would need to find if any string in column T contains the word "FEES" and if so, extract the preceding word plus FEES in the adjacent column.
Example, description in T1:
999-TRANSFER: Y.REF.83237 O.REF.USERINT-MSCI SWFPRCXXXXXPRC TRANSFER OF USD 3,150.00 IN FAVOUR OF ENTITY1 MGT FEES Q2 2023 |
Result in cell U1:
MGT FEES
If "MGT FEES Q2 2023" was possible that would be even better.
NB, The string FEES can appear anywhere in the description and the length of it is variable.
Example 2:
999-TRANSFER: Y.REF. O.REF.USERINT-HNOL SWFPRC039XXXXXPRC TRANSFER OF USD 24.63 IN FAVOUR OF ENTITY2 VAT FEES 2022 AT A FX RATE OF .92828962 FX PAYMENT EQUIVALENT TO EUR 22.86 |
The expected result here should be:
VAT FEES
or
even better, VAT FEES 2022
Appreciate any suggestions, thank you!