Prevent text from overflowing

  • Thread starter Thread starter bcsia
  • Start date Start date
B

bcsia

Is there an *easy* way to prevent text from flowing into
the cell to the right, when that cell is empty?

If A1 contains "happy birthday" and A2 contains nothing, I
want to see only the number of characters that fit in A1
("happy bir" by default).

I know that there are a few complex tricks or compromises
(like using wrap text and then decreasing the height of
the row to something rediculously small), but if there is
an easier way, I'd love to know it.

Thanks.
 
From the way I read your message, There are two ways. The
easiest is to go to the column that contians the text
that you want to fit. Put the cursor directly over the
line to the right of the cell and double click with left
mouse button. This will automatically set this column to
fit the widest entry. Or hold the left mouse button and
resize column to desired size.
Adam
 
I'm afraid I wasn't clear in my message.

I want to *hide* any text that doesn't fit. I don't want
to resize the column. Ok, here's a better example:

The text in A1 is:

"01234567 Smith Bob"

I want ONLY 01234567 to show. I have sized the columns
perfectly to accomplish this. However, if there is no
value in A2, then the entire contents of A1 is visible.

Basically, I want the same affect as if I put a value
of " " (empty) in A2.

I hope that's clearer.

Thanks for your suggestion.
 
It's really best to keep one thread going on a particular subject, instead
of fragmenting it.
That way all respondents can have all the information and input available to
them so that you could perhaps get a better and/or quicker solution.
Plus, it helps the keep the search engine archives more complete.

With your additional input in this thread, I can't think of an easy way to
accomplish what you wish, but, maybe you could change the color of the data
that you wish to hide.
You could select that "secret" part of the data in the formula bar, and then
format it to white.
That makes it invisible in the WB column, but visible in the formula bar.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
put a single quote in B1 (not A2??)

I like to put a formula (it helps me remember what I'm doing (and easier to
notice):

=""
 
Talking about starting a new thread,
The OP's later (earlier ?!?) thread stated this type of fix was not
acceptable because a user could type over it and *then* delete the "type
over", exposing the "secret" data.
--


Regards,

RD
 
I saw your post, but didn't see where that other thread was. (I did remember
the question, though. <VBG>)
 
Back
Top