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

J

JDN

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
 
I

Ian

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.
 
R

Roger Govier

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
 
J

JDN

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
 
Top