Excel MID function

by Kalika   Last Updated September 11, 2019 19:01 PM - source

What formula can I use to extract variable length strings, where all I know is the beginning and end points of the string. So for example, I have a large list of transactions where I need to extract the text between the "*", which are different lengths and sometimes different characters. (examples below)

REMARK=TRN*1*3107979027*000000000
REMARK=TRN*1*7037/09-10-19*0000000
REMARK=TRN*1*001270017788519*0000000

Thanks!



Related Questions





Select 1st day of each user id in excel

Updated December 19, 2018 07:01 AM

Text function in Excel isn't formatting year

Updated February 07, 2019 07:01 AM