+ Reply to Thread
Results 1 to 2 of 2

Text overflow

  1. #1
    Registered User
    Join Date
    03-27-2015
    Location
    Bristol, England
    MS-Off Ver
    2010
    Posts
    4

    Text overflow

    I want to know if there is a way of setting the size of a cell, then referencing text from another cell to fill it and, if this text is larger than the cell size, having that overflow to another non-adjacent cell.

    This would be in much the same way that you can use overflow in text boxes in publisher and I believe powerpoint.

    Many thanks,

    Alex

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,154

    Re: Text overflow

    As far as I know, there is no such mechanism available for excel cells :-(

    If I propoerly understand what you mean by "referencing text from another cell" it could be to some extend (but badly) simulated
    Could be improved a bit from the below sample with spaces location recognition, but anyway - nothing as nice_and_easy as in Publisher.

    So just for fun - not recommended in real life :-)

    Say in A1 you wrote:
    The quick brown fox jumps over the lazy dog
    in C3 you could write formula like:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    in H3 you could write:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    in M3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    in M6 (we do not have to stic to one row):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    in H6 (we do not have also to always go right :-) ):
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and in C6:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    (of course it will remain empty at the moment, bit if you change A1 to:
    The quick brown fox jumps over the lazy dog as we all know
    the text will flow also into it.
    Attached Files Attached Files
    Best Regards,

    Kaper

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 12-29-2011, 08:07 AM
  2. text overflow in a shape
    By mwc48910 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2011, 08:56 AM
  3. Stop text overflow into next cells?
    By baubert in forum Excel General
    Replies: 1
    Last Post: 05-27-2007, 11:30 PM
  4. [SOLVED] allow text to overflow into the next cell?
    By gbwoodman in forum Excel General
    Replies: 1
    Last Post: 02-07-2006, 08:45 AM
  5. Text Cell Overflow
    By tonymaguire in forum Excel General
    Replies: 4
    Last Post: 10-06-2005, 03:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1