Reference concatenated cell on another sheet

Question

On sheet 1 I have a text column that represents part of a project name. I have a second column that represents the 2nd part of a project name (both just text strings). In a 3rd column on the same sheet I concatenate the first two columns in order to get a complete project description (see attached image 1).

On a 2nd sheet I want to reference the combined project name so I simply say= and pick the combined column cell on sheet1. However, when I do so, it only displays the formula:

=Projects!D:2 (see image 2) and not the combined project name from Sheet 1.

I am sure this is something very simple but can someone please shed light on what I need to do to get the combined values to show up correctly on the 2nd sheet?

Thanks in advance for your help!

riny_van_eekelen · Answer

Scott Duffin&nbsp;In the Formula ribbon, perhaps you clicked the "Show formulas" button.&nbsp;

scott duffin · Answer

Riny_van_Eekelen&nbsp;&nbsp;Thanks for responding.&nbsp; I tried that but it still doesn't work.&nbsp;I created a new workbook and copied all the cells back in and now it works.&nbsp; I guess somehow the workbook became corrupt or something else is going on.Thanks for your help!