Do you mean you've tried Ctrl-Shift-~ or just Ctrl-~

The one with the Shift key formats the cells as General; the one without the
Shift key toggles the sheet between showing formulas and results.

You likely have the cells formatted as Text. Change them to General by
selecting the offending range and pressing the Ctrl-Shift-~ key combinations.

Hope this helps

Duke

"MeredithWSR" wrote:

I am trying to use the "Concatenate" function to join two columns in a third
column (ie Mr. + Jones=Mr. Jones). On a blank spreadsheet with sample data,
this works fine, but in my existant spreadsheet, I cannot get it to work. I
feel like the spreadsheet must have some setting activated that is preventing
the formula from calculating the result, but I can't figure out what it is.
I have tried the "Control-grave accent" step described in Help, but this is
not the problem. Any idea what the problem is? Thanks!