S Shabbo Member Nov 2, 2018 #1 Dear Sir, In attached sheet I Wanted to get bank reference number highlighted I wanted it in column A as mentioned in example. Attachments Bank Reconcilation for finding reference number.xls 16 KB · Views: 14
Dear Sir, In attached sheet I Wanted to get bank reference number highlighted I wanted it in column A as mentioned in example.
B bosco_yip Excel Ninja Nov 2, 2018 #2 A1, copied down : =MID(B1,FIND("-",B1,FIND("-",B1)+1)+1,13) Regards Bosco