+ Reply to Thread
Results 1 to 7 of 7

Text Overflow to Different Cell

  1. #1
    Registered User
    Join Date
    08-21-2017
    Location
    Central Texas
    MS-Off Ver
    Office 2016
    Posts
    8

    Text Overflow to Different Cell

    I am using a Google form to capture information and insert it onto an Excel spreadsheet. One of the fields has the potential to exceed one page (the ultimate document will be printed). Is there a way for Excel to recognize that the text exceeds the size of the cell (on page 1) and therefore truncate the data in that cell, and then placing the remainder of the text into another cell (on page 2)?

    There will be static information above and below the cells in question, so allowing the text to just flow onto another page is not workable. I've also tried the truncate (LEFT/RIGHT) formula, but it is too rigid - not taking into account whole words or any spaces between paragraphs.

  2. #2
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,803

    Re: Text Overflow to Different Cell

    If I understand correctly, you should be able to do this. The best way to get help though is to upload a sample file. Take a look at the yellow banner at the top of this page for uploading files.

  3. #3
    Registered User
    Join Date
    08-21-2017
    Location
    Central Texas
    MS-Off Ver
    Office 2016
    Posts
    8

    Re: Text Overflow to Different Cell

    Sorry for not attaching an example. The text comes from the 'Form Data'!I2 and is transferred to 'Multi Page'!A15 (page 1) and the text overflow is supposed to goto 'Multi Page'!A68 (page 2). Sample workbook attached..
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,803

    Re: Text Overflow to Different Cell

    See if I'm understanding correctly. First of all, I entered 3900 in cell BD1 as the maximum number of characters you'd want for the "first page", so you can change it without having to change the formula.
    Try this in Cell A15:
    =LEFT(LEFT('Form Data'!I2,BD1),FIND(CHAR(1),SUBSTITUTE(LEFT('Form Data'!I2,BD1)," ",CHAR(1),BD1-LEN(SUBSTITUTE(LEFT('Form Data'!I2,BD1)," ","")))))
    (I edited this formula AFTER I uploaded the file attached)

    and this in cell A68:
    =RIGHT('Form Data'!I2,LEN('Form Data'!I2)-LEN(A15))

    I'm uploaded a sample
    Attached Files Attached Files
    Last edited by Gregb11; 12-11-2019 at 11:01 PM. Reason: Updating forumula

  5. #5
    Registered User
    Join Date
    08-21-2017
    Location
    Central Texas
    MS-Off Ver
    Office 2016
    Posts
    8

    Re: Text Overflow to Different Cell

    I think that's going the right direction. Maybe a better way i could explain it is to say, limit the rows of wrapped text?

    So, in this example - 39 rows of wrapped text, spaces, symbols, etc. would go in A15, but then the next 46 rows of wrapped text, spaces, symbols, etc. would go to A68. And, while we're at it, ideally the text is justified.

    I did find an older thread that looked promising, but wasn't solved (here it is in case it's helpful: [https : // www .excelforum.com/excel-formulas-and-functions/900920-count-the-number-of-rows-lines-in-a-wrap-text-cell.html]. I can't post a direct link as I haven't posted enough. I'm not sure if it's proper etiquette to post the formula from another post or site without properly assigning credit.

    And I came across some other information (different site) indicating that this can possibly be accomplished with macros. I'm not opposed to macros, I've just never used them.

  6. #6
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    2,803

    Re: Text Overflow to Different Cell

    So you have to have the number of rows rather than the number of characters? I don't know how to do that. I looked at the link but it didn't seem to have an answer there either.

  7. #7
    Registered User
    Join Date
    08-21-2017
    Location
    Central Texas
    MS-Off Ver
    Office 2016
    Posts
    8

    Re: Text Overflow to Different Cell

    I think limiting rows would be the preferred solution as I wouldn't have to figure out the character count each time there is a formatting change or other modification to the structure of the now 'document'.

    I do appreciate your assistance in this matter. I will be using your advice until I am able to figure out how to limit the wrapped text row.

+ 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. Text overflow in a cell - the right way ( Soft hyphen )
    By lord anubis in forum Excel General
    Replies: 5
    Last Post: 05-30-2018, 12:10 PM
  2. [SOLVED] Cell text overflow to adjacent cell
    By Axmed.cm in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 03-31-2018, 03:51 AM
  3. Text overflow
    By alex.harrison in forum Excel General
    Replies: 1
    Last Post: 04-02-2015, 12:52 PM
  4. Replies: 3
    Last Post: 12-29-2011, 08:07 AM
  5. text overflow in a shape
    By mwc48910 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-23-2011, 08:56 AM
  6. [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
  7. 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