Collapse data within a cell

[Collapse]

I downloaded a set of data that instead of making a free-
flowing paragraph within a cell, it gives the paragraph
that is separated by line breaks within the cell. As
such, I am not able to format the cell appropriately such
that I can collapse the height and expand the column.

One possible solution I thought of would be to find and
replace all line breaks within cells with a space and thus
have all the data collapse into one complete sentence, but
this does not seem to work.

Could someone help?

EXAMPLE

I would like to have the cell include data in this form.

But the cell
shows the data
abbreviated
like this.

 

[Stan Scott]

You can use the CLEAN function to remove non-printable characters from text.

Stan Scott
New York City

 

[keepITcool]

however the linebreaks ARE printable..
the characters to be replaced are either CHAR(10), CHAR(13) or
a combination.. thus following should clean both:

=substitute(substitute(a1,char(10),""),char(13),"")



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >