+2Hi 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.
Best answer by TheTimeSavingCo
Try something like:
LEFT(
{Full Text},
FIND(
"Ingredients",
{Full Text}
) - 1
)Which will give you this:
+31Try something like:
LEFT(
{Full Text},
FIND(
"Ingredients",
{Full Text}
) - 1
)Which will give you this:
+2Try something like:
LEFT(
{Full Text},
FIND(
"Ingredients",
{Full Text}
) - 1
)Which will give you this:
Hey! That worked! The only thing is I have some spaces before the text. Is there anyway to remove those spaces?
+31Hey! 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()`
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.