Use the CLEAN() function. If the problem text is in column B, insert a new
column C and use

=CLEAN(B1)

and copy it down. Then Edit-Copy all the new cells, and use Edit-Paste
Special-Values to convert them to constants


"Teric506" wrote:

Hello,

I have exported a document to excel and one of my rows have descriptions in
it. When I exported it over it brought over all these return marks and when
you click on one cell, it has part of the decription than four blank lines
and then more of the description. Is there an easy way to get rid of all
those blank lines within the cell. I put an example of this below this is
everything that is inside of one cell - you see there is the first part, than
blank lines and then another part. Any help would be great.
Teri


MISC, HEAT SHRINK TUBING, 1/2 EXP x 1/4" ALPHA FIT-221-1/4-4B






058-005-064