Hi all,
Please can you help me with a code where the Column D till the last row (range varies) will return the letters:
1). 'SW' : if values in Column F till the last row ( range varies) starts with numbers
2). 'IB' : if values in Column F starts with two letters ( just like IBAN numbers) and the numbers - the character length is greater than equal to 15.
Thanks in advance
Please can you help me with a code where the Column D till the last row (range varies) will return the letters:
1). 'SW' : if values in Column F till the last row ( range varies) starts with numbers
2). 'IB' : if values in Column F starts with two letters ( just like IBAN numbers) and the numbers - the character length is greater than equal to 15.
Thanks in advance