If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
CONCATANATE
How to concatanate two fields. Entered =concatanate(a2,b2). Getting #NAME?
|
#2
|
|||
|
|||
CONCATANATE
=concatEnate()
or =a2&b2 And avoid typos! And if you're combining dollars/dates, you may want something like: =text(a2,"mm/dd/yyyy") & " " & text(b2,"$#,##0.00") nlogan wrote: How to concatanate two fields. Entered =concatanate(a2,b2). Getting #NAME? -- Dave Peterson |
#3
|
|||
|
|||
CONCATANATE
concatEnate
with an 'e' -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "nlogan" wrote: How to concatanate two fields. Entered =concatanate(a2,b2). Getting #NAME? |
#4
|
|||
|
|||
CONCATANATE
OR use & as below
=A2&B2 -- Jacob (MVP - Excel) "nlogan" wrote: How to concatanate two fields. Entered =concatanate(a2,b2). Getting #NAME? |
Thread Tools | |
Display Modes | |
|
|