| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I can't get my concatenate formula results to show
When I go to Insert, Funciton, chose concatenate, then the cells I want to
merge, I can see the correct results, but once I hit OK and the wizard closes I can only see the formula =concatenate(A2,B2) - I have tried the CTRL + ` to swith between views but no luck |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I can't get my concatenate formula results to show
It sounds like the cell was formatted to Text before you entered
the formula. Change the format to General and press F2 then Enter. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Lauren" wrote in message ... When I go to Insert, Funciton, chose concatenate, then the cells I want to merge, I can see the correct results, but once I hit OK and the wizard closes I can only see the formula =concatenate(A2,B2) - I have tried the CTRL + ` to swith between views but no luck |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I can't get my concatenate formula results to show
ToolsOptionsViewwindow options uncheck the formulas check box
"Lauren" wrote: When I go to Insert, Funciton, chose concatenate, then the cells I want to merge, I can see the correct results, but once I hit OK and the wizard closes I can only see the formula =concatenate(A2,B2) - I have tried the CTRL + ` to swith between views but no luck |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I can't get my concatenate formula results to show
Lauren
What you are doing should work but have you tried just using the ampersand (&) eg =A2&B2. I find this a lot easier and more flexible. Roger "Lauren" wrote: When I go to Insert, Funciton, chose concatenate, then the cells I want to merge, I can see the correct results, but once I hit OK and the wizard closes I can only see the formula =concatenate(A2,B2) - I have tried the CTRL + ` to swith between views but no luck |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display the results not the formula in the task bar | Excel Worksheet Functions | |||
| View formula results instead of formula in 2003 version? | Excel Discussion (Misc queries) | |||
| Use a text box to calculate and show results in a user form | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| If Greater than when a formula Results in N/A | Excel Worksheet Functions | |||
Hybrid Mode
