Thread: How do I add "@" into a field without making it concatenate?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
  
Posts: 2,819
Default How do I add "@" into a field without making it concatenate?
"&" is concatenate

Ann from uniondale wrote:

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?

Reply With QuoteReply With Quote