Wrapped text cell formatting

[cyrusewm]

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?

 

[wi_guy]

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.

 

[cyrusewm]

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

 

[Jack in the UK]

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.....

 

[cyrusewm]

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"

 

[Von Pookie]

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

 

[Barry Katcher]

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.