LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default 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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting Column Letter Rob Excel Programming 11 May 14th 08 08:59 PM
About sorting and extracting data in one column Ting Li Excel Worksheet Functions 7 June 9th 07 01:59 AM
Extracting specific data from one column to another column DK Excel Programming 2 June 16th 06 02:22 PM
Extracting only when column contains a certain value AmyTaylor[_54_] Excel Programming 1 April 28th 06 12:08 PM
Populate a column by extracting unique values from another column? Mike Palmer Excel Worksheet Functions 2 June 10th 05 03:21 PM


All times are GMT +1. The time now is 06:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"