Thread: Pasting multiple lines of text into one cell

I have to transfer some date from PDF's to an Excel spreadsheet. Sometimes I want to grab several lines of text and put it in one cell. However, if I copy the following text, for example:

Multiple lines of text Multiple lines of text Multiple lines of text Multiple
lines of text Multiple lines of text Multiple lines of text Multiple
lines of text Multiple lines of text Multiple lines of text Multiple lines of text


and then try to paste into a cell in Excel, it pastes into three cells instead. Anyway to change this default behavior?

No, unfortunately not. You can automatically recombine them in column B by using the formula

Code:

=A2&CHAR(10)&A3&CHAR(10)&A4

and format the cell alignment to Wrap text. Then Copy and Paste special (values) for column B on top of itself and delete column A.

ChemistB

well i can!
just copied
Multiple lines of text Multiple lines of text Multiple lines of text Multiple
lines of text Multiple lines of text Multiple lines of text Multiple
lines of text Multiple lines of text Multiple lines of text Multiple lines of text

all into cell a1 ok.
click to get cursor in cell before pasting!

Oops, I stand corrected.
Nicely done, Martin

ChemistB