How to concatanate two fields. Entered =concatanate(a2,b2). Getting #NAME?
D Dave Peterson May 27, 2010 #2 =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")
=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")
