Pull data from one field and add it to another field in the same table?

[fodcj]

I have a single table where I have different columns for Town, County, Region etc. I then have a Description field with some generic copy but at the end I want to automatically add the Town name within its row (see image).

E.g. Town: Aaron's Hill

Description:  Welcome to the beautiful town of {Town}

Seems like a fairly basic requirement but I've done a lot of Google searching and I can't find the answer. Any help very much appreciated  🙏

 

[ScottWorld · Accepted solution]

You would create a formula field that looks like this:

"Welcome to the town of " & {Town}

Hope this helps! You can learn even more about formula fields in my free Airtable training course, which you can take for free by signing up for a free 30-day trial with LinkedIn Learning. 

— ScottWorld, Expert Airtable Consultant

[fodcj]

Thanks @ScottWorld . That worked for what I described.  I then tried to add two parts to the sentence so the  'Town' appears in the middle but this through an error. Is there a way to do the below?

"We are your go-to partner in " & {Town} ". Whether you're a homeowner tackling a DIY project or a construction professional managing a large-scale job, we've got you covered. With us, its easy and affordable."

System said: Sorry, there was a problem saving this field. Invalid formula. Please check your formula text.

[ScottWorld · Accepted solution]

You will need to add another ampersand (the & symbol) before your quoted text. You use that symbol to connect different pieces of text in your formula. 

[fodcj]

Your a star, thanks @ScottWorld   🙏