How to Extract Text with the MID Formula in Airtable

Within an Airtable database, it's common to need to extract or "pull" text from a long string. There are many reasons you may want this, ranging from social media posts to contract creation. Luckily, the methodology for extracting the desired text is always the same: reference the string, find out where to start, and find a length of characters to extract.

Now sometimes, your starting position and length will be constant. If so, then this is a much easier formula to write! But, in the majority of cases, you'll want a dynamic variable for your starting position and length. In these cases, a more robust formula is required.

In this video, I walk through the two formulas that we will need to use in tandem to produce a dynamic output. Check it out and follow along in your own database to perfect your formula skills!

Life is too short to fight with spreadsheets

Enter your info below to get my FREE Airtable Crash Course to discover how to use automations to get your time (and sanity) back.

Close

50% Complete

You're almost there!

Get our FREE Airtable Crash Course delivered to your inbox!