pasting a block of text into one cell

[jezzica85]

Hi everybody,
I'm trying to paste a few passages from a book, surrounded by a trim()
command, into a single cell of a worksheet. Since this has multiple lines,
and tabs at the beginning of each line, the paste occurs in multiple rows and
the trim() command doesn't work. Does anyone know how to paste something like
this into one cell?

For clarity, the block is like this:
=trim( "
blah
blahhhhhhh
zzzzz
")
(with tabs before each line)

Is there any way to do this? Any help would be greatly appreciated.

Thanks,
Jezzica85

 

[ShaneDevenshire]

Hi,

Try the =CLEAN(A1) function.

 

[Gary''s Student]

If you have textual material that you have copied and wish to paste into a
single cell, click in the formula bar and paste there.

 

[jezzica85]

Thanks Gary's Student,
That was perfect.
Jezzica85