Formula works but formula shows in cell???
 

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

Formula works but formula shows in cell???
 

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

HTH,
Paul


"Donald King" wrote in message
...
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

Formula works but formula shows in cell???
 

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


On Mon, 30 Oct 2006 11:51:01 -0800, Donald King
wrote:

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