try the CLEAN function

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"chosen-girl" wrote:

I am working in Excel 2007. I have a column with cells containing different
lengths of text. The control is set on wrap text with bottom alignment. 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. Trim does not work to remove the space. Any suggestions?