Wrapped text cell formatting
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Wrapped text cell formatting

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    A report was sent to me with a limited width for one page width purposes. One of the columns is formatted to wrap the text. some of the cells wrap the text with no space between the top and bottom of the cell while others are putting a space above the data. There are no formatting differences. Why and what can I do to make the space go away?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I would create a new column that references that one you need cleaned up, for instance, if the old data started in a1..... =trim(a1))
    ....then copy and paste:special:values back over this original data.


  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried that but it won't get rid of the mystery space. there are no leading or trailing spaces to trick it or anything like that but for some reason, it thinks there should be a space.

    [ This Message was edited by: cyrusewm on 2002-04-02 12:00 ]

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    TRIM i use all day everyday the advice is correct..

    add column =TRIN(left or right cell) return

    All spaces bar one in each word space is removed.. will always works....

    Copy / paste special/ paste as value.. delete original cell or better spaste specuial an original column and delete trim column.. neat trick..

    HTH.....

    OR

    do you have non printable charaters like square and so on.....


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Maybe i misworded my problem...The data in the cells (text data) will not fill the row height. however, the auto row height thinks it should have blank space for one line before starting the text.

    "
    xxxx,xxxx,xxxx
    xxxx,xxxx,xxxx"

    is how it is showing up but the actual text in the cell is

    "xxxx,xxxx,xxxx
    xxxx,xxxx,xxxx"


  6. #6
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Are you positive they're formatted the same? Looks to me like there may be some hard returns in there...
    Kristy

  7. #7
    Board Regular Barry Katcher's Avatar
    Join Date
    Feb 2002
    Location
    Dog Beach, Florida. Yeaahh!
    Posts
    4,053
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I've had this problem myself - don't know why it sometimes happens, sometimes doesn't. Only solution I've found is to manually decrease the height of the cell by clicking on the row number at the left and dragging up to shorten it.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com