Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Feb 2014
    Posts
    3
    Thanks
    3
    Thanked 0 Times in 0 Posts

    continuous space keeps on going to next next line in wrapped text

    I ran into a problem with the spacing in a wrapped cell. I used to keep on pressing space to get to the next line when I use excel. I think i accidentally pressed some button causing all the redundant space to be reflected in the wrapped cell. instead of stopping at the end of line 1, it goes on to line 2 as well, causing all my documents to mess up. Can any one shine some light on how to solve the problem? Thanks so much!error.jpg

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Instead of using space to force the wrapping, if you enter <alt>+<enter> you put a linefeed character in the cell which will wrap at that position.

    Steve

  3. The Following User Says Thank You to sdckapr For This Useful Post:

    wesleyjilu (2014-02-18)

  4. #3
    New Lounger
    Join Date
    Feb 2014
    Posts
    3
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks for the prompt reply!

    Since most of my documents are already typed in such a format, is there any way to truncate the space at the end of the wrapped cell and let text start from the next line? The problem now is that the extra space that should have ended on line 1 is shifted to line 2, causing the text to go all over the place. Thanks so much for your advice!

  5. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    I often type in Word the copy and pasting into the cell using the formula bar, not directly into the cell itself. It seems to keep the format fairly well

    HTH,
    Maud

    Copy from Word:
    wrapping.png

    paste into Excel:

    wrapping3.png

  6. The Following User Says Thank You to Maudibe For This Useful Post:

    wesleyjilu (2014-02-18)

  7. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You could first find the high number of spaces and replace with a linefeed (alt-0010). If you have any extra spaces after that find dbl-spaces and replace with a single space.

    Steve

  8. The Following User Says Thank You to sdckapr For This Useful Post:

    wesleyjilu (2014-02-18)

  9. #6
    New Lounger
    Join Date
    Feb 2014
    Posts
    3
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Thanks everyone for your help. Problem solved! I found out that all it took was restart the excel software and every thing was in the right position again.

Posting Permissions

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