View Single Post
  #11  
Old March 28th, 2011, 10:04 PM
allysonstewart allysonstewart is offline
Member
 
First recorded activity by OfficeFrustration: Mar 2011
Location: Missouri
Posts: 2
Smile

Quote:
Originally Posted by educationnest View Post
When I copy and paste into excel, the result gives me multiple lines. I want a single line, with the exact multiple text in a single cell. How can I do this?? Nobody in the world seems to know.
Hi, educationnest

Not sure if this is what you're referring to, but you can copy and paste the data as usual. Then try wrapping the line you want to format. To do that, click the cell that's overlapping the other cells on your spreadsheet. Go to the "Home" tab and "Cells" group and click 'Format" and "Format Cells." Select the "Alignment" tab in the dialog box and check "Wrap text."

If you're trying to merge separate cells however, Excel will only retain the top, left cell's data. Checking the "Merge cells" option in the same dialog box will combine those cells for you but remove data from the bottom cells. I'm quite sure you want to retain the data in all cells. If so, this option won't work.

Hopefully, I didn't totally misunderstand your question and hope this helps.