ExcelBanter - CONCATANATE

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - CONCATANATE (https://www.excelbanter.com/excel-worksheet-functions/264714-concatanate.html)

nlogan

CONCATANATE

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

Dave Peterson

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

Gary Brown[_6_]

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?

Jacob Skaria

CONCATANATE

OR use & as below

=A2&B2

--
Jacob (MVP - Excel)

"nlogan" wrote:

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

All times are GMT +1. The time now is 06:50 PM.