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

Several errors, not least saying how it didn't work.

1. There's no function named CONCANTENATE. You want CONCATENATE.

2. You show 01 as one of the arguments. That's two numerals, a zero and
a one. I suspect you meant O1 - a capital letter o (the letter between
N and P) followed by the numeral one.

3. The critical problem is that you try to use more than 30 function
arguments. Excel is archaic in some places, and this is one of them.

You could use multiple nested CONCATENATE calls, e.g.,

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

but there's NEVER a good reason to use CONCATENATE rather than using
the concatenation operator, &. Change your formula to

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