Formula works but formula shows in cell???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Donald King - 30 Oct 2006 20:51 GMT

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

Reply to this Message

PCLIVE - 30 Oct 2006 21:00 GMT

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

HTH,
Paul

>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
[quoted text clipped - 6 lines]
>
> DonK

Reply to this Message

Gord Dibben - 30 Oct 2006 21:54 GMT

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

>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
[quoted text clipped - 4 lines]
>
>DonK

Reply to this Message