I fill out missing information letters and often required material is missing
from more than one field. I want to be able to fill in the explanation for
missing information in field 1 and field two into the same cell, which
content will be merged into a letter.

Right now, I can use =A1 to fill up the cell with an explanation found in
A1, but I can't reference more than one explanation to the cell.

I've tried =A1, A2 to get explanations to multiple fields in one cell, but
it doesn't work. Concatenate function doesn't work either.

The easier the better.

Maybe...

=a1&a2
or
=a1&" "&a2
or
=a1&char(10)&a2
(with format|cells|alignment tab|wraptext checked)



JKSommers wrote:

I fill out missing information letters and often required material is missing
from more than one field. I want to be able to fill in the explanation for
missing information in field 1 and field two into the same cell, which
content will be merged into a letter.

Right now, I can use =A1 to fill up the cell with an explanation found in
A1, but I can't reference more than one explanation to the cell.

I've tried =A1, A2 to get explanations to multiple fields in one cell, but
it doesn't work. Concatenate function doesn't work either.

The easier the better.

--

Dave Peterson

Perhaps I'm not getting this but why dosen't concatenate work? Have you tried

=CONCATENATE(A1,", ",A2)

or just

=A1&", "&A2

"JKSommers" wrote:

I fill out missing information letters and often required material is missing
from more than one field. I want to be able to fill in the explanation for
missing information in field 1 and field two into the same cell, which
content will be merged into a letter.

Right now, I can use =A1 to fill up the cell with an explanation found in
A1, but I can't reference more than one explanation to the cell.

I've tried =A1, A2 to get explanations to multiple fields in one cell, but
it doesn't work. Concatenate function doesn't work either.

The easier the better.