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