+ Reply to Thread
Results 1 to 7 of 7

Text is wrapped but word is broken

  1. #1
    Registered User
    Join Date
    12-31-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Text is wrapped but word is broken

    Hi, my name is Denise. After watching many tutorials for my online class, I am attempting the Assignment. I have everything else like it is supposed to be, but in one cell a word is broken. I have tried everything and gone back through the tutorials. Can anyone help me correct this? What do I do? Excel 2007.
    Attached Images Attached Images
    Last edited by DeniseHunter; 12-31-2012 at 10:44 AM. Reason: Requested

  2. #2
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Text is wrapped but word is broken

    Denise,

    You need to make the cell just a little wider to accommodate all the letters without breaking up the word.

    Hope this helps.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  3. #3
    Registered User
    Join Date
    12-31-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Text is wrapped but word is broken

    Thanks, but how do I do this?

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Text is wrapped but word is broken

    Hi Denise,

    Guessing this is column C? Go to the column letters and inbetween C and D there is a line, click on the line and you will see a black plus, drag to the right or left. In your case, right to widen.

    You can also right click on column C, select column width and set a value.
    HTH
    Regards, Jeff

  5. #5
    Registered User
    Join Date
    12-31-2012
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Text is wrapped but word is broken

    It worked! I learned something new! Thank you and Brendan for taking the time to help me out. It is so appreciated, Happy New Year to you both

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,327

    Re: Text is wrapped but word is broken

    You are very welcome and thanks for the feedback. We are all glad to have been able to help.

    Happy New Year

  7. #7
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Text is wrapped but word is broken

    Glad you're sorted, Denise. Thanks for the rep, and happy new year to you, too.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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