masterpath
New Member
- Joined
- Oct 18, 2018
- Messages
- 1
I have the texts below from a bank statement:
'A BAHTUI , COTTON AVENUE 47 , VIA ONLINE - PYMT , FP 28/02/20 10 , 60125454141400000N
'A CUNNINGHAM , EYLEWOOD ROAD 48 , VIA ONLINE - PYMT , FP 27/09/19 40 , 31023358147272000N
'A IDOWU , SEDGEBROOK RD 32 , VIA ONLINE - PYMT , FP 10/01/20 40 , 38023333789920000N
Is there anyone who can help me with a formula to pick the 2nd "," ?
for eg on the first text, finding the first "," will return 11, I need a formula to pick the 2nd "," which should return 30
Thanks in advance
'A BAHTUI , COTTON AVENUE 47 , VIA ONLINE - PYMT , FP 28/02/20 10 , 60125454141400000N
'A CUNNINGHAM , EYLEWOOD ROAD 48 , VIA ONLINE - PYMT , FP 27/09/19 40 , 31023358147272000N
'A IDOWU , SEDGEBROOK RD 32 , VIA ONLINE - PYMT , FP 10/01/20 40 , 38023333789920000N
Is there anyone who can help me with a formula to pick the 2nd "," ?
for eg on the first text, finding the first "," will return 11, I need a formula to pick the 2nd "," which should return 30
Thanks in advance