Hi
I have the following function extracting data from a seperate workbook

=TEXT([SurveillanceDup.xls]RDBMergeSheet!B2,)

Data is extracted to the new workbook

When I use
=TEXT([SurveillanceDup.xls]RDBMergeSheet!A2,)

No data is extracted

There is data on Column A and B the SurveillanceDup.xls.

This is a strange one

Has anyone any ideas?

Thanks
Eddie