concatenate cell with text

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate an Area (Range) 5
Concantenate which keeps bold of some parts. 5
Excel: Replace strings with a Matrix formula 6
Nested IF conditions 3
Excel Concatenate with line breaks but ignore blank cells 3
Concatenate multiple lines 2
cell displays formula instead of value 4
How to set cell value to emptry if three other columns are empty too 1

Top