Thread
:
How do I add "@" into a field without making it concatenate?
View Single Post
#
3
Posted to microsoft.public.excel.misc
Gaurav[_3_]
external usenet poster
Posts: 127
How do I add "@" into a field without making it concatenate?
Assuming your data is in column A starting A1, enter the following in B1
=A1&"@xxx"
Drag it down as far as needed.
"Ann from uniondale" <Ann from
wrote in
message ...
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 Quote
Gaurav[_3_]
View Public Profile
Find all posts by Gaurav[_3_]