View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hardeep_kanwar[_2_] Hardeep_kanwar[_2_] is offline
external usenet poster
 
Posts: 103
Default 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?