When extracting from column A no data
 

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

When extracting from column A no data
 

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

On May 5, 1:14*pm, webels wrote:
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

When extracting from column A no data
 

On May 5, 2:13*pm, webels wrote:
OK I just figured it is something to do with TEXT, but cannot find
another function.

On May 5, 1:14*pm, webels wrote:



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"

When extracting from column A no data
 

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.



webels wrote:

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

When extracting from column A no data
 

On May 5, 2:21*pm, Dave Peterson wrote:
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.





webels wrote:

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.