cell referencing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Perhaps I'm not getting this but why dosen't concatenate work? Have you tried

=CONCATENATE(A1,", ",A2)

or just

=A1&", "&A2
 
You must log in or register to reply here.

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

TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Excel Making a cell Mandatory 9
Function for summing or counting cells based on a specified fill color 2
Formula to answer YES or No 4
Concatenation help 8
Nameing a function 1
Average formula where blank cells are counted as zeros 4
Auto-fill 1

Back
Top