I am trying to take information from an existing worksheet and create a one
sheet for each row of the worksheet using some of the columns. I am trying
to combine columns, and when I paste the data to another worksheet, it comes
up as #REF!. I widened the column, but the data did not appear. Does that
help? And, yes I have asked several questions and didn't get any answers, so
that is why I am asking again.

"Duke Carey" wrote:

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