Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Wrapping text problem (Office 2003 SP2 )

    Hi there,

    I have a user that is trying to use Excel as a data source for a fairly large mail merge exercise. Some of the text entries within cells are fairly long, and although she has set the cells to wrap text, where there is a lot of text the top section of the cell wraps and the last few lines don't, they just cut off. They don't even appear to the right of the cell if it is blank as you would expect were wrapping not selected.

    All the text is still there, you can see it in the formula bar and when you perform the mail merge all the text is brought over, however she needs to print out the spreadsheet and therefore is missing some text from the larger cells. Is there a limit to the amount of text that will sit within a cell or anything that could impact on cell wrapping? Just in case this makes no sense to anyone I have attached a sample sheet where I have been able to replicate the problem.

    Thanks in advance for any help you may provide
    Alba
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Wrapping text problem (Office 2003 SP2 )

    Excel is not a word processor, it is not very good at wrapping text in cells. If your user really needs to have large amounts of text in a cell, it would be better to us a table in a Word document as data source for the mail merge.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wrapping text problem (Office 2003 SP2 )

    Normally I would agree that the user should be using Word, however the mail merge that they are trying to achieve is so large that I cannot get it onto a Word document. Even when making the page size as large as possible - I can only see about half of the width of the table they are using as the source.

    Another issue that is creeping in is that when performing the mail merge some of the contents of the cells fail to appear properly - the text is being cut off at between 260-265 characters - only on some cells, other cells are much longer and the entire text is appearing correctly within the merge.

    I have tried copying the entire sheet to a new workbook, format painting the problem cells from the cells that merge correctly, changing the cell format between general and text, reducing the font size..can anyone else think of any reason why this would happen or suggest any way round it??

    Thanks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Wrapping text problem (Office 2003 SP2 )

    I don't know of a way round this in Excel. Is there any chance that you can use an Access database as data source? A memo field in Access can hold a very large amount of text, and Access has no problems displaying memo fields.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wrapping text problem (Office 2003 SP2 )

    Excellent idea Hans - I'll give that a go!

    Alba

  6. #6
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Renfrewshire, Scotland
    Posts
    121
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wrapping text problem (Office 2003 SP2 )

    Worked like a charm Hans - tho I had to do it for her as she doesn't have Access!!

Posting Permissions

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