View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Driftwood Driftwood is offline
external usenet poster
 
Posts: 31
Default linked workbook (cells) does not show entire length of original te


All my staff have a daily activity report, in which they have columns in
which the input specific information.
One such column (CO) is used as a simple "LOG" in which they can type in
anything they think may be of concern.
Then in a master workbook, I have a formula in each cell to populate what I
want to pull from and see from each individual on a daily basis Example:
For the "LOG" column on a specific day, for a spefic member:

=IF('I:\Share\Quality Assurance\1QA
Associates\ROBBI\[DAR_RE09.xls]DAR'!CO232<"",'I:\Share\Quality Assurance\1QA
Associates\ROBBI\[DAR_RE09.xls]DAR'!CO232,"")

The ONLY problem I have is that it will only read 260 characters of the up
to 1500 or so actually typed into a (wrapped text) cell by the associate.
I have tried to add the function "LEFT([DAR_RE09.xls]DAR'!CO232,2000)", but
the text still stops reading after the 260th character.

How can I get my IF - formula to read the entire cell input of a workbook it
is linked to? OR how do I format the MASTER to read more than it is currently?

Thanks in advance
Driftwood