My formula will not show the result, only the formula.

[Guest]

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!

 

[Guest]

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

 

[Guest]

Yes! Thank you-worked like a charm.

 

[Bob Phillips]

What does happen if it doesn't work?

You could try

=A1&" "&B1

see if that suffers the same.

--

HTH

RP
(remove nothere from the email address if mailing direct)