Formula works but formula shows in cell???

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top