I have a very simple workbook, just names and address. In cell B2, I am
using the CONCATENATE formula as follows:
=CONCATENATE("Attn: ",E2)
The formula is what shows in the cell and not the result. In the little
popup window that you use to fill in the formula, it shows the results
correctly, just not in the cell??????

Your cell was formatted as text before you entered the formula. Format as
General and re-enter the formula (F2, ENTER)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"stumpy" wrote in message
...
I have a very simple workbook, just names and address. In cell B2, I am
using the CONCATENATE formula as follows:
=CONCATENATE("Attn: ",E2)
The formula is what shows in the cell and not the result. In the little
popup window that you use to fill in the formula, it shows the results
correctly, just not in the cell??????

1. Select B2.
2. Press <Ctrl<Shift<~.
3. Press F2.
4. Press <Enter.

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a very simple workbook, just names and address.
In cell B2, I am
using the CONCATENATE formula as follows:
=CONCATENATE("Attn: ",E2)
The formula is what shows in the cell and not the
result. In the little
popup window that you use to fill in the formula, it
shows the results
correctly, just not in the cell??????
.