Hopefully there's a simple explaination for this quirky behaviour.....
I have a workbook with numerous sheets. In, say, Sheet1, a concatenation formula such as =A1&A2 gives the expected results, regardless of the contents of the cells A1 and A2.
However, on, say, Sheet2, the same formula, looking at cells A1 and A2 on Sheet2 which contain exactly the same data as the cells on Sheet1 behave strangely. If both cells contain text, the concatenation works fine. If I change one of the cells to contain a number, or a date, the result is a #VALUE! error.
Any ideas why this would work fine in one sheet and not another?
Cheers in advance,
wadjssd
I have a workbook with numerous sheets. In, say, Sheet1, a concatenation formula such as =A1&A2 gives the expected results, regardless of the contents of the cells A1 and A2.
However, on, say, Sheet2, the same formula, looking at cells A1 and A2 on Sheet2 which contain exactly the same data as the cells on Sheet1 behave strangely. If both cells contain text, the concatenation works fine. If I change one of the cells to contain a number, or a date, the result is a #VALUE! error.
Any ideas why this would work fine in one sheet and not another?
Cheers in advance,
wadjssd