pasting a block of text into one cell

  • Thread starter Thread starter jezzica85
  • Start date Start date
J

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
 
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.
 
Back
Top