I have a simple workbook with names and address. In cell B2 I have the
following formula, =CONCATENATE("Attn: ",E2)
This is what shows in the cell, not the result of the formula. I have the
formula =SUM($G2:$R2) formula in cell F2 and it shows the results ok. When
you first type the formula a popup window shows up to help, the results show
correctly in this window, just not in the cell?????

Press Ctrl+`
That's the Ctrl Key and the button that's frequently directly below Esc.

tj

"stumpy1220" wrote:

I have a simple workbook with names and address. In cell B2 I have the
following formula, =CONCATENATE("Attn: ",E2)
This is what shows in the cell, not the result of the formula. I have the
formula =SUM($G2:$R2) formula in cell F2 and it shows the results ok. When
you first type the formula a popup window shows up to help, the results show
correctly in this window, just not in the cell?????

See my answer to your earlier post

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"stumpy1220" wrote in message
...
I have a simple workbook with names and address. In cell B2 I have the
following formula, =CONCATENATE("Attn: ",E2)
This is what shows in the cell, not the result of the formula. I have the
formula =SUM($G2:$R2) formula in cell F2 and it shows the results ok.
When
you first type the formula a popup window shows up to help, the results
show
correctly in this window, just not in the cell?????