CONCATENATE is a useless function. You can simply use the & operator
instead. E.g.,

="Hello"&" "&"World"


For a VBA function that *vastly* improves upon CONCATENATE, see
http://www.cpearson.com/excel/StringConcatenation.aspx

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sat, 8 Aug 2009 11:27:01 -0700, Taffy
wrote:

I tried to reply to a Concatenate Formula question and it is unavailable so I
will post it this way your concatenate formula should read =CONCATENATE(A1,"
","&"," ",B1).