| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add "@" into a field without making it concatenate?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run macro only if Field E10 = "WO ID" and AB10 = "Spec Sizing" | Excel Discussion (Misc queries) | |||
| Run macro only if Field E10 = "WO ID" and AB10 = "Spec Sizing" | Excel Discussion (Misc queries) | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| Making a "Filter" button or field | Excel Discussion (Misc queries) | |||
| Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) | |||
Linear Mode
