| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting Column Letter | Excel Programming | |||
| About sorting and extracting data in one column | Excel Worksheet Functions | |||
| Extracting specific data from one column to another column | Excel Programming | |||
| Extracting only when column contains a certain value | Excel Programming | |||
| Populate a column by extracting unique values from another column? | Excel Worksheet Functions | |||
Linear Mode
