Formula works but formula shows in cell???

[Guest]

I am attempting to concatenate two columns and put the result into a 3rd
empty column. I keyed into cell C3 =A3&B3 and hit enter. All that shows in
Cell C3 is A3&B3 as a text value. If I click on the = sign to edit the
formula, the result of the concatenation shows just fine while editing. If I
click OK, the result doesn't appear but just the text '=A2&B3'. This is
probably simple, but frustrating...

DonK

 

[PCLIVE]

Try pressing:
Ctrl + `
` is the symbol above Tab.

HTH,
Paul

 

[Gord Dibben]

Donald

The cell(C3) with the formula is probably formatted as Text.

Re-format to General then hit F2 and ENTER


Gord Dibben MS Excel MVP