I am trying to extract alpha-numeric string of data between two characters (*) . The placement and the length of the string is not consistent throughout the spreadsheet, but it always comes after TRN*1*. I need to see all numbers/letters between the two * (colored in red in the sample below). Thank you!
PAYMENT: PYMT ID:11111111 INDN:COMPANY NAME CO ID:11111111 CCD PMT INFO:TRN*1*2222222ABCDE*12345678910-
Bookmarks