Hi,
I'm having an issue in one workbook only, that when I reference another cell, even on the same sheet, it shows the cell address instead of the value.
For example, if I wanted to add "Mr." to a a name in a2 I typed ="Mr. "&a2 and it returns ="Mr. "&a2 instead of the "Mr. text in a2"
I'm having an issue in one workbook only, that when I reference another cell, even on the same sheet, it shows the cell address instead of the value.
For example, if I wanted to add "Mr." to a a name in a2 I typed ="Mr. "&a2 and it returns ="Mr. "&a2 instead of the "Mr. text in a2"