functions are not displaying the results

J

janeisaac100

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)
 
B

Bob Phillips

Perhaps the cell is formatted as text, if so, change the format to General.
Or you may have formula view, Options>Tools>View and check the Formulas
checkbox.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top