Skip to main content

Formula to extract text between constant strings

  • September 25, 2019
  • 2 replies
  • 45 views

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

2 replies

  • Author
  • New Participant
  • September 25, 2019

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


Justin_Barrett
Forum|alt.badge.img+21

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


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: