Skip to main content

Hello everyone,


I need to add text before each word in an already established Formula column.


Example:

Formulas Column Results : ENG, SPA, FRA, RUS, ITA

I want to add “Title” and a underscore before each text resulting in: Title_ENG, Title_SPA, Title_FRA, Title_RUS, Title_ITA


Current formula is:

IF({Title (No Special Characters)}, “” & {Title (No Special Characters)}) & IF({Audio Languages}, “_” & {Audio Languages})



Thank you in advance!

To do what you want, use SUBSTITUTE() to replace all instances of ", " with ", " followed by the title and an underscore


IF({Title (No Special Characters)}, "" & {Title (No Special Characters)}) & IF({Audio Languages}, "_" & SUBSTITUTE({Audio Languages}, ", ", ", " & {Title (No Special Characters)} & "_"))

Reply


Terms & Conditions