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.


--
slamming_sammy1
------------------------------------------------------------------------
slamming_sammy1's Profile: http://www.excelforum.com/member.php...o&userid=32368
View this thread: http://www.excelforum.com/showthread...hreadid=521285

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

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.


--
slamming_sammy1
------------------------------------------------------------------------
slamming_sammy1's Profile: http://www.excelforum.com/member.php...o&userid=32368
View this thread: http://www.excelforum.com/showthread...hreadid=521285

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.


--
slamming_sammy1
------------------------------------------------------------------------
slamming_sammy1's Profile: http://www.excelforum.com/member.php...o&userid=32368
View this thread: http://www.excelforum.com/showthread...hreadid=521285

Glad to hear that you found a workaround. Thanks for feeding back.

Pete

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.


"Pete_UK" wrote:

Glad to hear that you found a workaround. Thanks for feeding back.

Pete