WRAP TEXT vs. BLEED TEXT vs. CUTOFF TEXT

I'm trying to make a long string of text in a cell disappear instead of bleeding or wrapping.

I know how to Wrap Text

When inserting along string of text in a cell (like a URL), there is a wrap text option that looks like this:

User uploaded file

When this is checked:

The text is (obviously) wrapped by the left/right borders of the cell. In other words, the horizontal width of the cell/column remains the same while the vertical length of the cell/row adjusts to fit the text, making the entire text visible. It looks like this:

User uploaded file


When this is NOT checked:

The text, in it's horizontal entirety, bleeds past the right border of the cell, making it look like this:

User uploaded file


When I add text to the cell to the right (in D2):

Then and only then does the text (in C2) cut off or disappear like I need it to, like this:

User uploaded file


How do I make this happen without placing text in the cell to the right?

MacBook Pro with Retina display, OS X El Capitan (10.11.3), null

Posted on Mar 19, 2016 6:41 AM

Reply
6 replies

Mar 20, 2016 12:58 PM in response to Yellowbox

If you want to avoid having and hiding the extra column, you can also paste the URL directly into the HYPERLINK function.


As in Ian's example, enter the link-text, enclosed in quotes, in place of the link-text lozenge.

The click on the URL lozenge and enter two quotes.

Place the insertion point between the quotes, and paste the URL text.

In the edit box, your formula should now look like this:

User uploaded file

Click the green check or press return to confirm the entry


Regards,

Barry

Jul 31, 2016 9:15 PM in response to SaphrynShikaze

Hi Saphryn,


To make a Hyperlink shorter, the HYPERLINK function with link-text may work for you.


The HYPERLINK function creates a clickable link that opens a webpage or new email message.

HYPERLINK(url, link-text)

  • url: A standard universal resource locator. url is a string value that must contain a properly formatted universal resource locator string.
  • link-text: An optional string value that specifies the text that appears as a clickable link in the cell. If link-text is omitted, url is used as link-text.


User uploaded file

Using the url of this discussion as an example in Column B, the formula in C2 =HYPERLINK(B2,"My question")

Now hide Column B

User uploaded file

Regards,

Ian.

Jul 31, 2016 10:51 PM in response to SaphrynShikaze

HI Saphryn,


Reread this as it popped up again today, and it triggered a thought:


"Text flows into the adjacent (empty cell) on the side(s) away from the alignment of the text in the cell.'


"So what happens if alignment is set to full justification?" I thought.


And the answer is—the text does not flow past the cell boundary in either direction, not does it 'stack up' in the cell as is the case with setting it to Wrap. It may, however, become widely spaced between characters, as Numbers attempts to align it to bothe the left ans right edges of the cell.


Tested with a URL.


Regards,

Barry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

WRAP TEXT vs. BLEED TEXT vs. CUTOFF TEXT

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.