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

Hi,

Add wrap text and then best fit row height.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Driftwood" wrote:


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

My master workbook has a macro that does the Autofit rowheight lalready...
the problem is also not the wrap text, as the cell that contains the formula
has been formatted for that.
the text is perfectly wrapped, the rowheight is fine, even when the row
height is increased, you can only read the first 260 characters, and not the
entire text from the original.But thanks for the concern, still appreciate
everyones input, I can always overlook something.

THX
Driftwood.

"Shane Devenshire" wrote:

Hi,

Add wrap text and then best fit row height.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Driftwood" wrote:


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