I am attempting to use string concatenation with the formula: =$B57&", "&$D57
When typing this formula for the first time, it correctly concatenates the contents of the referenced cells, however, upon reopening the file after save, the formula displays in the cell and not the value of the formula.