Help

Re: Formula to extract text between constant strings

404 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Brett_Power
5 - Automation Enthusiast
5 - Automation Enthusiast

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 2
Brett_Power
5 - Automation Enthusiast
5 - Automation Enthusiast

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: