How to concatanate two fields. Entered =concatanate(a2,b2). Getting #NAME?

=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

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?

OR use & as below

=A2&B2

--
Jacob (MVP - Excel)


"nlogan" wrote:

How to concatanate two fields. Entered =concatanate(a2,b2). Getting #NAME?