Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Add text before a word in a formula column

Topic Labels: Formulas
1382 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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})

Screen Shot 2020-06-30 at 2.03.24 PM

Thank you in advance!

1 Reply 1

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)} & "_"))

Screen Shot 2020-07-01 at 8.46.40 AM