ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Remove Space in Cells (https://www.excelbanter.com/new-users-excel/181926-re-remove-space-cells.html)

[email protected]

Remove Space in Cells
 
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.


All times are GMT +1. The time now is 09:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com