Excel Formula: How to @Mention contact

[NeoSez]

I want to particularly call out someone in my excel email list.
I tried

="Attention "@&($A$1)&" yada yada yada."

But when it creates the email it shows up as Attention @"&($A$1)&" yada yada yada.
It should appear as : Attention @contact yada yada yada.

By the way, this blurb above is part of another cell formula (B1) that calls on this cell (C1) above as there is a limit on how much text I can put into B1.
Can someone tell me what I did wrong?
Thank you for your input.

 

[Coding4Fun]

Maybe try

="Attention @" & ($A$1) & " yada yada yada"

 

[NeoSez]

Maybe try

="Attention @" & ($A$1) & " yada yada yada"

Thanks mate. I already tried that and it didn't work either. I think the @ symbol throws things off. Not sure how else to automate calling out someone. Ideas?

 

[wolf735]

try =Textjoin(" ",true,"Attention","@",a1,"yada yada yada") that one thing i can think. hope it helps.

 

[wolf735]

this is what i meant top is evaluated formula bottom is the raw formala.

A	Attention @ A yada yada yada	Attention @A yada yada yada
A	TEXTJOIN(" ",TRUE,"Attention","@",E19,"yada yada yada")	SUBSTITUTE(F19,"@ ","@")

 

[Coding4Fun]

Thanks mate. I already tried that and it didn't work either. I think the @ symbol throws things off. Not sure how else to automate calling out someone. Ideas?

Maybe I misunderstood your request