Forum Discussion
Reference concatenated cell on another sheet
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 ...
A cell number formatted as 'text' may also show a formula rather than evaluate it.