how to paste text with CR into one row?

S

slamming_sammy1

Hello,

I want to paste some lines of text with carriage returns into one row,
and can't seem to do it. Excel paste them into multiple rows.
please let me know if you know how to do this.
thanks.
 
P

Pete_UK

Suppose they have gone into cells A1 to A4. In B1 you could enter this
formula:

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

and then fix the values by selecting the cell, clicking <copy> then
Edit | Paste Special | Values (check) then OK and <Esc>. You can then
delete A1 to A4.

Hope this helps.

Pete
 
S

slamming_sammy1

Hi Pete,

thanks for your suggestion. but it didn't work.
They still span multiple rows. I'd hate to have to go back and edit
the text document and remove all the hard returns to have this to work
right.
 
S

slamming_sammy1

I found a workaround.
here's what I did:
click on the cell that I'll be pasting these texts. press F2, then do
several Alt-Enter to create some space, then paste. this works great.
 
R

ruks

Hi, One way to do that would be to copy the text you want, click on the
appropriate cell, move cursor to formula bar and use paste function by right
clicking the mouse. I found text usually retians it carriage returs spacing
and tabs etc.
 
Top