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)