| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I remove extra space when text wrapping?
Try This
Press CTRL+H Find What : ALT+0160 Replace With: Blank Ok Note: When you type 0160 in find What Hold the ALT Key While Entering the 0160 "chosen-girl" wrote: I am working in Excel 2007. I have a column with cells containing various lengths of text. The control is set on wrap text and the alignment is on bottom. The problem is that all of the cells look fine on the screen, however, when I print there is added space (a whole blank line) at the beginning of some of the cells. The cells are not sizing themselves properly. Trim does not work to remove the space. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove extra space when text wrapping? | Excel Discussion (Misc queries) | |||
| Remove an extra space after a number. | Excel Worksheet Functions | |||
| How do I remove a space infront of text in a cell? | Excel Discussion (Misc queries) | |||
| Issues with white space when printing & with wrapping text | Excel Discussion (Misc queries) | |||
| Remove Space in Text | Excel Discussion (Misc queries) | |||
![Hardeep_kanwar[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
