concatenate cell with text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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