concatenate cell with text

G

Gilles P (FR)

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

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

Any idea ?
Thanks for your help
Gilles Provost
 
R

Ron Rosenfeld

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

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

Any idea ?
Thanks for your help
Gilles Provost
Click to expand...

=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
 
Top