how do I stop my text being truncated at RHS of a cell?
 

Hi,

Have an Excel report generated by MYOB (small bus accounting package). The
first few columns should format the chart of accounts using a 'tree'
structure.

The issue is that the text is these cells doesn't display past the RHS cell
boundary. i.e. rather than running over into the adjacent cell, the display
is truncated at the rhs cell boundary.

I want this:
Assets
Current Assets
Bank Accounts
Wachovia Checking Account

I get this:
Ass
Curr
Bank
Wachovia Checking Account

How do I tell Excel to allow the text in the first three columns to display
in their entirety?

Thanks,
JD

There is probably dat in the adjacent cells (maybe just spaces). Excel will
not carry data over to an adjacent cell if that cell is occupied. Delete the
content of these cells (once you are sure it is nothing of use) and your
titles shouldflow across.

--
Ian
--
"JDN" wrote in message
...
Hi,

Have an Excel report generated by MYOB (small bus accounting package).
The
first few columns should format the chart of accounts using a 'tree'
structure.

The issue is that the text is these cells doesn't display past the RHS
cell
boundary. i.e. rather than running over into the adjacent cell, the
display
is truncated at the rhs cell boundary.

I want this:
Assets
Current Assets
Bank Accounts
Wachovia Checking Account

I get this:
Ass
Curr
Bank
Wachovia Checking Account

How do I tell Excel to allow the text in the first three columns to
display
in their entirety?

Thanks,
JD

Hi

If the cell to the right of the text is empty, then it should continue the
display past the right boundary. Try pressing the delete button on the
adjacent cells.

Regards

Roger Govier


JDN wrote:
Hi,

Have an Excel report generated by MYOB (small bus accounting package). The
first few columns should format the chart of accounts using a 'tree'
structure.

The issue is that the text is these cells doesn't display past the RHS cell
boundary. i.e. rather than running over into the adjacent cell, the display
is truncated at the rhs cell boundary.

I want this:
Assets
Current Assets
Bank Accounts
Wachovia Checking Account

I get this:
Ass
Curr
Bank
Wachovia Checking Account

How do I tell Excel to allow the text in the first three columns to display
in their entirety?

Thanks,
JD

Yes, I think Ian and Roger are closing in on the issue. What I didn't
mention in the original post is that the columns that create the tree
structure contain simple formulas in each cell, i.e.:

col c =IF(A1="1", B1, "") [i.e Assets]
col d =IF(A1="2", B1, "") [i.e Current Assets]
col e =IF(A1="3", B1, "") [ie. Bank Accounts]
col f =IF(A1="4", B1, "") [i.e Wachovia Bank Account]

I'd guess that returning the empty string might be the problem. Is there a
different solution?

Thanks, JD

Click and drag the range of cells immediately to the right of the text which is being truncated, then right click and select "Clear Contents"

This should remove everything from a cell, even unprintable characters and null strings, allowing text initiated to the left of it to flow across it without getting truncated.