The debit credit formula work fine, but the formula to extract name doesn't work properly. The names of the customers are all the capitalized letter at the end of the line. TRSF E-BANKING CR 2701/FTSCY/WS95051 10000.00 deposit CHRISTINE, I want to extract "CHRISTINE" only, not "deposit CHRISTINE". For line 4: TRSF E-BANKING CR 2701/FTSCY/WS95051 5000.00 Msn1888 JOSH BROWN 5,000.00 CR, it should extract "JOSH BROWN", instead of "Msn1888 JOSH BROWN". Thanks.
Bookmarks