ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   functions are not displaying the results (https://www.excelbanter.com/excel-worksheet-functions/72043-functions-not-displaying-results.html)

[email protected]

functions are not displaying the results
 
For some reason, my functions are not displaying their results in the
cells. All that shows up is the function itself.

What am I missing? Here's a simple example of a concatenate function to
combine two columns that contain the city and the state into one
column.

This is also what is displaying in the cell - what should have
displayed was Peoria, IL

=CONCATENATE(G3,", ",H3)


Bob Phillips

functions are not displaying the results
 
Perhaps the cell is formatted as text, if so, change the format to General.
Or you may have formula view, OptionsToolsView and check the Formulas
checkbox.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
ups.com...
For some reason, my functions are not displaying their results in the
cells. All that shows up is the function itself.

What am I missing? Here's a simple example of a concatenate function to
combine two columns that contain the city and the state into one
column.

This is also what is displaying in the cell - what should have
displayed was Peoria, IL

=CONCATENATE(G3,", ",H3)





All times are GMT +1. The time now is 09:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com