LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
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
Formatting cells to show length of time in Days and hours David Biddulph[_2_] Excel Discussion (Misc queries) 1 January 9th 08 07:34 PM
Formatting cells to show length of time in Days and hours Tyro[_2_] Excel Discussion (Misc queries) 0 January 9th 08 08:28 AM
Maximum Length For Linked Workbook Path? MDW Excel Worksheet Functions 2 May 7th 07 07:37 PM
Linked Cells Staying With Cells Once Linked Workbook Update. [email protected] Excel Worksheet Functions 0 June 6th 06 09:32 AM
Show cells have been read - linked ufo_pilot Excel Discussion (Misc queries) 0 August 5th 05 04:22 PM


All times are GMT +1. The time now is 12:48 PM.

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"