Home |
Search |
Today's Posts |
#1
|
|||
|
|||
My formula will not show the result, only the formula.
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
Yes! Thank you-worked like a charm. :)
"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! |
#4
|
|||
|
|||
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) "MeredithWSR" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy a result without copying the formula? | Excel Discussion (Misc queries) | |||
sum of the result from the formula? | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
formula displayed instead of the result ??? | Excel Worksheet Functions |