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