Cell shows formula and not the result of the formula.

S

stumpy

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

Niek Otten

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
 
J

Jason Morin

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

HTH
Jason
Atlanta, GA
 

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

Copying formulas across columns 2
Cell shows formula and not the result of the formula. 2
Concatenate cells with line breaks in them 4
Cell reference in formula string displays abbreviated value 2
formula displays as a formula, not as its result 1
Concatenating two text strings, formula is right, cell output is w 3
Lookup against concatenated source value 4
VLOOKUP source values are a formula result. Getting #N/A 7

Top