Formula to extract text between constant strings

[Brett_Power]

I have a field that contains two strings that will always be constant: " - Device S/N: " and " - Dongle key S/N: ". I want to extract the serial number from in between these two constants. My biggest issue is that the character positions will always vary.

Any ideas on how I can do this? MID, LEFT, MATCH, don’t seem to work at all.

Here is a sample of the cell contents that I am working with:

Device name: NewTom GO 3D - Device S/N: 708K0078 - Dongle key S/N: 1-1555622170

[Brett_Power]

I think I have it figured out. I’'ll post when I am sure.

[Justin_Barrett]

Checking in to see if you got this worked out, or if you still need help. If you figured it out, sharing your solution might help others. :winking_face: