 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Remove Space in Cells
Greetings, again. I hope I'm not getting too annoying by posting so often, but I can't solve this problem on my own. I am using MS Excel 2007. I have a column with cells full of text, the word count of which is of various length. The cells are aligned (horizontal) left (indent) and (vertical) top. The text control is wrap text. The problem is that some cells have spaces between the end of the text in the above cell and the beginning of the next cell below. To help visualize this: ___________________________ For score and seven years ago our forefathers brought forth.... ----------------------------------------- To be or not to be .... But I want the cells to look like this: For score and seven years ago our forefathers brought forth.... ------------------------------------------ To be or not to be .... Format autofit row height does not remove this extra space at the bottom of some cells. Do any of the experts have any suggestions? Please remember that most of the cells are OK. That is, there is no waste of space between the cells. Thanks. >Greetings, again. I hope I'm not getting too annoying by posting so often, >but I can't solve this problem on my own. I am using MS Excel 2007. I have a [quoted text clipped - 23 lines] >most of the cells are OK. That is, there is no waste of space between the >cells. Thanks. It may be that your column is just a wee bit too narrow, so first widen it just a bit; then select the cell or row, click the Home tab, click Format in the Cells group, and then click AutoFit Row Height. --ron Thanks, Ron, but I don't want to change the column width, so I guess I'm out of luck. And even if I did change it, wouldn't that produce other cells that would have "wasted space" at the bottom of the cells? Then I would have to adjust the width again, and ... well, you get the picture. > >Greetings, again. I hope I'm not getting too annoying by posting so often, > >but I can't solve this problem on my own. I am using MS Excel 2007. I have a [quoted text clipped - 29 lines] > > --ron >Thanks, Ron, but I don't want to change the column width, so I guess I'm out >of luck. And even if I did change it, wouldn't that produce other cells that >would have "wasted space" at the bottom of the cells? Then I would have to >adjust the width again, and ... well, you get the picture. If the column width must be fixed, you could adjust these aberrant row heights manually. Another option might be to use a fixed width font. --ron Hi Rebecca, There is a function called TRIM. It removes all spaces from a text except single spaces between words. If your texts start at A1, use a blank column, eg Column B and insert =TRIM(A1) Copy down to the end of your text cells. You could then select all the trimmed cells in column B, copy, select A1, Paste Special, Values, then delete the contents of column B. Regards - Dave. >Hi Rebecca, >There is a function called TRIM. It removes all spaces from a text [quoted text clipped - 5 lines] >A1, Paste Special, Values, then delete the contents of column B. >Regards - Dave. Dave, The TRIM function removes extraneous <space> characters. I believe the OP is concerned about an extra blank line at the bottom of a word-wrapped cell. --ron Hi Ron / Rebecca Perhaps the following then: =CLEAN(TRIM(A1)) Dave. >Hi Ron / Rebecca >Perhaps the following then: >=CLEAN(TRIM(A1)) >Dave. How would that work, exactly? As I understand the issue, it is NOT that there are any extraneous characters in the text; rather the problem is how Excel handles the word-wrap when the column is just slightly too small to accommodate the spacing of the final character. --ron Hi Ron, CLEAN would remove any "endline" thingies inserted with ALT+Enter at the end of each text which XL may be responding to. But if the issue is as you say, then this will not help. I have tried to reproduce the effects described in the original request, and find that if the column width is sufficiently tight on any line in the text, XL does put in an extra blank line, even though it doesn't need to. However, using "Justify" in the vertical text alignment does at least look a little better. Dave.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.