extracting data

[simon4amiee]

695515*97
531924*11
495853*131
377035*181

Is there a way to extract the 97, 11, 131, 181 numbers from the above list in a separate field?

 

[pr2-eugin]

You could use a combination of Mid, InStr functions.

? Mid("695515*97", InStr("695515*97", "*") +1)
97