New to Formulas...Can I insert a character?

[chrisberry]

I have this formula as 1 of 3 parts that's extracting certain bits of data from a reference cell into 3 adjacent cells. What I'm wondering is if I can add something to get a specific character insert BEFORE the info...

Example
reference cell contains : flavor1, flavor2, flavor3 
This part below pulls out "flavor1" into a 2nd cell
I'd like it to do that but add a " / " before the flavor
So the result would be " / flavor1"

IF( FIND(",", FlavorsLookup1_1),

LEFT({FlavorsLookup1_1},

FIND(",", {FlavorsLookup1_1})-1

),

{FlavorsLookup1_1}

)

Thoughts/suggestions are appreciated in advance.

[Sho · Accepted solution]

Adding text is easy.

IF( FIND(",", FlavorsLookup1_1),
  "/ " & LEFT({FlavorsLookup1_1},
    FIND(",", {FlavorsLookup1_1})-1
  ),
  "/ " & {FlavorsLookup1_1}
)

I would like to introduce here a new function in Airtable, the ALLAYSLICE function.
It is available for Lookup and Rollup fields from the Formula field (or Rollup field).
When used in your formula, for example, it will look like this

"/ " & ARRAYSLICE({FlavorsLookup1_1}, 1, 1)

This function cannot be used directly to the "Link to other table" field, so you need to add a lookup field with the Flaver name.