Wrapped text cell formatting

cyrusewm · Apr 2nd, 2002, 12:37 PM

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 · Apr 2nd, 2002, 12:56 PM

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 · Apr 2nd, 2002, 12:59 PM

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 · Apr 2nd, 2002, 01:11 PM

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 · Apr 2nd, 2002, 01:17 PM

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 · Apr 2nd, 2002, 01:50 PM

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

Barry Katcher · Apr 2nd, 2002, 02:38 PM

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.

Apr 2nd, 2002, 01:11 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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"

Apr 2nd, 2002, 01:50 PM	#6
Von Pookie MrExcel MVP, Administrator Join Date: Feb 2002 Location: The act or process of locating. Posts: 13,679	Are you positive they're formatted the same? Looks to me like there may be some hard returns in there... __________________ Kristy How to post (Video) Show your sheet on the board (HTML Maker FAQ)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 12:37 PM	#1
cyrusewm New Member Join Date: Apr 2002 Posts: 3	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?

Apr 2nd, 2002, 12:56 PM	#2
wi_guy Board Regular Join Date: Mar 2002 Posts: 50	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.

Apr 2nd, 2002, 12:59 PM	#3
cyrusewm New Member Join Date: Apr 2002 Posts: 3	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 ]

Apr 2nd, 2002, 01:17 PM	#5
cyrusewm New Member Join Date: Apr 2002 Posts: 3	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"

Apr 2nd, 2002, 02:38 PM	#7
Barry Katcher Board Regular Join Date: Feb 2002 Location: Dog Beach, Florida. Yeaahh! Posts: 4,038	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.