Variables in forumulas

Hi,

can i do a formula to replace a certain word in a column

column a = month
column b = adtext containing text including [MONTH]
column c = adtext with text replacing word [MONTH] with column a

Thanks!

This topic has been closed for replies.

+4

Hi @Carl-Henrik_Sjostrom

You could use the Substitute formula function in Column C like this:

SUBSTITUTE({Column B},’[Month]’, {Column A})

I suggest you have a look at Airtable’s formula reference here:

Hope this helps!

Amazing, thanks @Julian_Kirkness!

Sign up