concatenate cell with text

[Gilles P (FR)]

Hello,
I need to CONCATENATE text:
A B C D
1 To Ta (empty) Tu

Formula "=CONCATENATE(A11)" doesn't work....
and matrix formula "{=CONCATENATE(A11)}" doesn't work too.... (result is
"To")

Any idea ?
Thanks for your help
Gilles Provost

 

[Nick Hodge]

Gilles

Why not just

=A1&B1&C1&D1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Ron Rosenfeld]

Hello,
I need to CONCATENATE text:
A B C D
1 To Ta (empty) Tu

Formula "=CONCATENATE(A11)" doesn't work....
and matrix formula "{=CONCATENATE(A11)}" doesn't work too.... (result is
"To")

Any idea ?
Thanks for your help
Gilles Provost

=concatenate(a1,b1,c1,d1)

Otherwise you will probably need a VBA solution, or the MCONCAT function from
Longre's free morefunc.xll add-in available from http://xcell05.free.fr
--ron