I have some accounts data (exported as a csv file with no header) and have copied & Pasted it into my current workbook from the workbook it exports into.

It appears to have merged cells with data in (such as supplier name, invoice date, invoice value). on the worksheet itself I can get it to return the merged cell data in a single cell by using = pointed to the block of cells.
For example E13:E17 have a value of 2171. In cell F3 if you type = and hold over E14 (E14 has a fuzzy yellow outline) and click, E13:E17 turn blue with a blue outline, push return and cell F3 returns 2171

However, if I do this on a new sheet within the workbook it returns #VALUE!

Can somebody please advise what I am doing incorrect