How do I add "@" into a field without making it concatenate?

[Ann from uniondale]

I have a column of user names, to which I need to add "@xxx" to each name. I
tried adding a new column & putting in the "@xxx" with the thought that I
could then put the 2 columns together. However, the @ symbol is recognized
as concatenate within excel & it will not allow me to do that. Any ideas?

 

[Bob I]

"&" is concatenate

 

[Gaurav]

Assuming your data is in column A starting A1, enter the following in B1

=A1&"@xxx"

Drag it down as far as needed.