On Thu, Oct 14, 2010 at 3:48 PM, Brian Barker <b.m.bar...@btinternet.com>wrote:
> At 18:04 13/10/2010 +0530, Anand Warik wrote: > >> In spreadsheet Whenever i copy a long sentence & paste it in one cell >> instead of having every thing in one cell itself the sentence is split & >> pasted in number of rows. I want everything to remain in one cell. >> > > Like others, I am puzzled: if the original text is continuous and not > formatted as a number of paragraphs, I don't find this happens. > > But in any case, in addition to the suggestions already made, there is a > convenient workaround. > o Select all the cells into which the text has been pasted. > o Go to Format | Merge Cells (or click the Merge Cells button in the > Formatting toolbar). > o Answer "Yes" to "Should the contents of the hidden cells be moved to the > first cell?". (Note that Calc will even add intervening spaces.) The text > is now in a single merged cell. > o Go to Format | Merge Cells again (or click the Merge Cells button in the > Formatting toolbar again) to unmerge the cells and return the text to the > first of the cells - where you want it. > > (Oh, and to those who enjoy such things: you can't do that, I think, in > Excel!) > > I trust this helps. > > Brian Barker > > Hello, > I had this problem until someone told me that when you go to the cell you want to paste into, with the cursor in the top left corner, just hit the space bar to make one space and then do the paste and the result is what I think was wanted in the original post. You may notice that when you do the same for a second copy and paste to another cell when the space bar is moved the one space the previously copied text is there but is highlighted. Take no notice of that and just do the paste and the highlighted text is deleted and the new copy is in its place. This has saved me for ages now as it is annoying when you want everything in the one cell formatted as it was in the original. Hope this helps. meld...@gmail.com
