Thread: CONCATANATE
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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