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

Gilles

Why not just

=A1&B1&C1&D1

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(E-Mail Removed)DTHIS
www.nickhodge.co.uk


"Gilles P (FR)" <(E-Mail Removed)> wrote in message
news:22A3F435-4E15-4B62-8FB8-(E-Mail Removed)...
> 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

On Wed, 13 Dec 2006 22:59:00 -0800, Gilles P (FR)
<(E-Mail Removed)> wrote:

>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