Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
CONCATANATE
0 views
Skip to first unread message
nlogan
May 27, 2010, 4:46:03 PM5/27/10
to
How to concatanate two fields. Entered =concatanate(a2,b2). Getting #NAME?
Dave Peterson
May 27, 2010, 5:03:52 PM5/27/10
to
=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
May 27, 2010, 5:26:09 PM5/27/10
to
concatEnate
with an 'e'
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown
with an 'e'
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown
Jacob Skaria
May 27, 2010, 5:29:03 PM5/27/10
to
OR use & as below
=A2&B2
--
Jacob (MVP - Excel)
0 new messages