What do you mean "it doesn't work". You've asked several questions about
this formula. Perhaps if you gave us some sample data and an idea of what
you need to accomplish, we could solve this once and for all!


"Terri" wrote:

I am trying to take several columns of data and condense each row into a one
sheet of information to put in a binder. I have tried the following formula,
based on Microsoft Office Assistance for combining two or more columns by
using a function. It didn't work.

Here is the formula I tried:

=CONCANTENATE(A1, " ", C1, " ", G1, " ", I1, " ", J1, " ", CHAR(10), L1, "
", CHAR(10), M1, " ", N1, " ", 01, CHAR(10), P1, CHAR(10), Q1, " ", R1,
CHAR(10), U1, CHAR(10), W1, CHAR(10), X1, CHAR(10), Y1)

This is my first time trying this, and I see by the posts that a lot of you
have fantastic experience, so please tell me what I am doing wrong.

Thanks,

Terri