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

  • Thread starter Ann from uniondale
  • Start date
A

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?
 
G

Gaurav

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

=A1&"@xxx"

Drag it down as far as needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

concatenate entries from a column into a cell by logical AND withanother column 2
Concatenate with date range 7
How to CONCATENATE >50 fields in Excel table into SQL Insert State 3
How do I delete merged cells in Excel without deleting the final d 5
how insert the return key in formulas for concatenate of text? 2
Concatenate Multiple Cells into A Single Cell 2
How format number as text 6
combining two columns together 2

Top