Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the concatenate function in Excel to display results?
I'm using =CONCATENATE(g40,g41) and that is what is displayed in the cell.
I'm not getting the combined text strings from cells g40 and g41. When setting up the function arguments, the expected results are shown, but when I click "go" the spreadsheet doesn't display the correct result. I've tried just using text instead of cell numbers and I get the same results. Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the concatenate function in Excel to display results?
It sounds like the cell is formatted as text. Use Format | Cell |
Number (tab) and change it to General. Double-click in the cell (as if to edit it) then press <enter. Incidentally, you can reduce typing by changing your formula to: = G40 & G41 It means the same thing. If this doesn't cure it, you probably have the calculation mode set to manual. Press F9 to re-calculate at any time. To change to automatic calculation go to Tools | Options | Calculation (tab) and select automatic. Hope this helps. Pete |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the concatenate function in Excel to display results?
Do you mean that the cell just shows the actual formula? If so select cell and use EDIT REPLACE and replace = with = BTW a simpler formula is =G40&G41 -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=504235 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the concatenate function in Excel to display results?
or maybe you have the wrong view, check ToolsOptionsView and ensure that
Formulas is not checked. -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Pete" wrote in message ups.com... It sounds like the cell is formatted as text. Use Format | Cell | Number (tab) and change it to General. Double-click in the cell (as if to edit it) then press <enter. Incidentally, you can reduce typing by changing your formula to: = G40 & G41 It means the same thing. If this doesn't cure it, you probably have the calculation mode set to manual. Press F9 to re-calculate at any time. To change to automatic calculation go to Tools | Options | Calculation (tab) and select automatic. Hope this helps. Pete |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get the concatenate function in Excel to display resu
Thanks. I cut and pasted what you had below and it worked. Just for fun I
re-entered =CONCATENATE(g40,g41) and it worked too! "Pete" wrote: It sounds like the cell is formatted as text. Use Format | Cell | Number (tab) and change it to General. Double-click in the cell (as if to edit it) then press <enter. Incidentally, you can reduce typing by changing your formula to: = G40 & G41 It means the same thing. If this doesn't cure it, you probably have the calculation mode set to manual. Press F9 to re-calculate at any time. To change to automatic calculation go to Tools | Options | Calculation (tab) and select automatic. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple results display after filter function | Excel Worksheet Functions | |||
How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
Excel 2003 Slow Function Argument Window | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) |