Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to separate out text into a field based on a specific word?

139 3
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi there! I'm new to Airtable and trying to figure out how everything works. Let's say I have a cell that as the following information I inserted below: 

Beef Onion Burgers with Pickles

Ingredients:
2 hamburger patties
1 onion, diced
2 tablespoons ketchup
4 slices pickles
2 hamburger buns

How can I separate all of the text to the left of the word  "ingredients" into one cell? I basically am trying to extract the name of the recipe into its own cell.

3 Replies 3

Try something like:

LEFT(
  {Full Text},
  FIND(
    "Ingredients",
    {Full Text}
  ) - 1
)

 Which will give you this:

Screenshot 2022-12-31 at 10.28.01 PM.png

Hey! That worked! The only thing is I have some spaces before the text. Is there anyway to remove those spaces?

Sure, to do that put the formula above inside a `TRIM()`