Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula to extract text between constant strings

Topic Labels: Formulas
608 2
Showing results for 
Search instead for 
Did you mean: 

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

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: