Pasting mutiple paragraph text into a single cell

G

Guest

I want to cut and paste text that contains multiple paragraphs into a single
cell. By default excel puts each paragraph into a separate cell forming a
column of entries.

TIA

Peter
 
G

Guest

Thanks for the reply, I wasn't able to find my original post to check for
replies!! I couldn't search for my original mail by author and wasn't too
sure which Excel newsgroup it was in. The solution is fine, a little
cumbersome - shame there's not an option on pasting to force it into a single
cell but a lot better than the manual process I was using.

Thanks again,

Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pasting Word table cell with paragraph markers into single Excel c 1
Cut and Paste Text with CRLF into Single Cell 1
Pasting in paragraph of text, but with wordwrap? 7
Pasting into mutiple cells 2
Copying a table from Word 5
how to preserve paragraph breaks in pasted text? 4
Can I paste a paragraph of text into a merged cell? 3
Pasting text into one cell (Excel wants to dump in multiple cells)? 2

Top