I would try the following:
Select the column or Cell and go to "FORMAT CELLS" select "Alignment" -
"Vertical Alignment" - then select "TOP" and also ensure the "WORD WRAP
box is checked.
The default is usuall "bottom" and then if you have a narrow row - it
will sometimes only show the first line.
You might also have some paragraph returns entered. Insert a column
next to the column that needs to be "Cleaned" and then select the
"CLEAN" Function and then select the cell you want to "CLEAN"
--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile:
http://www.excelforum.com/member.php...o&userid=29640
View this thread:
http://www.excelforum.com/showthread...hreadid=495656