When extracting from column A no data

[webels]

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

 

[webels]

OK I just figured it is something to do with TEXT, but cannot find
another function.

 

[webels]

OK I just figured it is something to do with TEXT, but cannot find
another function.

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- Hide quoted text -

- Show quoted text -

OK sorted just remove TEXT "duuuuuh"

 

[Dave Peterson]

I tried:
=text(a1,)
in B1.

If A1 contained text, it showed up nicely.

But if A1 was a number, I didn't see anything. So I'm guessing you have a
number in that other cell.

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

 

[webels]

I tried:
=text(a1,)
in B1.

If A1 contained text, it showed up nicely.

But if A1 was a number, I didn't see anything.  So I'm guessing you have a
number in that other cell.

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

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Yeah Dave that is right, just remove text and do a direct extract from
A2 give the number.